Help: 80040e10
I've been almost everywhere, and have received numerous tips, but as of yet, none of them seem to work.
I was given the task of modifying an existing ASP page, and embedding the SQL in it below. The SQL runs perfectly from within Access, but when I try to run in within my ASP page, I get the following error:
***
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/Architecture/shawn_test2.asp, line 228
***
I've been thru the usual reasons (A field name was spelled incorrectly, One or more of the values was blank,Tried to insert the wrong datatype (e.g. surrounded a numeric value with quotes, or forgot to put quotes around a string), and reserved Access words. None of which seem to be the reason.
SQL
****
"SELECT " & _
"d_service_area.service_area AS ServiceArea, " & _
"d_environment.environment AS Environment, " & _
"d_platform_function.platform_function AS Platform, " & _
"d_hw_type.hw_type AS hdwType, " & _
"d_hardware.standard AS hdwHardware, " & _
"d_hardware.config_vrsn AS hdwVersion, " & _
"d_sw_type.sw_type AS sfwType, " & _
"d_software.standard AS sfwSoftware, " & _
"d_software.config_vrsn AS sfwVersion, " & _
"hw_sw.time_frame AS tf, " & _
"hw_sw.impl_plan_start_date AS pStDate, " & _
"hw_sw.impl_act_start_date AS aStDate, " & _
"hw_sw.impl_plan_duration AS pDur, " & _
"0 AS cmtTyp, " & _
"0 AS cmtSeq, " & _
""" "" AS cmt " & _
"FROM (d_service_area " & _
"INNER JOIN (d_platform_function " & _
"INNER JOIN (d_environment " & _
"INNER JOIN sa_env_pf " & _
"ON d_environment.environment_id = sa_env_pf.env_id) " & _
"ON d_platform_function.platform_function_id = sa_env_pf.pf_id) " & _
"ON d_service_area.service_area_id = sa_env_pf.sa_id) " & _
"INNER JOIN (d_sw_type " & _
"INNER JOIN (d_software " & _
"INNER JOIN (d_hw_type " & _
"INNER JOIN (d_hardware " & _
"INNER JOIN hw_sw " & _
"ON d_hardware.hardware_id = hw_sw.hardware_id) " & _
"ON d_hw_type.hw_id = d_hardware.hw_type_id) " & _
"ON d_software.software_id = hw_sw.software_id) " & _
"ON d_sw_type.sw_id = d_software.sw_type_id) " & _
"ON sa_env_pf.id = hw_sw.row_id_ref " & _
"WHERE d_service_area.service_area = 'telephone_services' " & _
"UNION ALL " & _
"SELECT " & _
"d_service_area.service_area AS ServiceArea, " & _
"d_environment.environment AS Environment, " & _
"d_platform_function.platform_function AS Platform, " & _
"d_hw_type.hw_type AS hdwType, " & _
"d_hardware.standard AS hdwHardware, " & _
"d_hardware.config_vrsn AS hdwVersion, " & _
"d_sw_type.sw_type AS sfwType, " & _
"d_software.standard AS sfwSoftware, " & _
"d_software.config_vrsn AS sfwVersion, " & _
"hw_sw.time_frame AS tf, " & _
""" "" AS pStDate, " & _
""" "" AS aStDate, " & _
""" "" AS pDur, " & _
"1 AS cmtTyp, " & _
"comments_main.comment_seq AS cmtSeq, " & _
"comments_main.comment AS cmt " & _
"FROM ((d_service_area " & _
"INNER JOIN (d_platform_function " & _
"INNER JOIN (d_environment " & _
"INNER JOIN sa_env_pf " & _
"ON d_environment.environment_id = sa_env_pf.env_id) " & _
"ON d_platform_function.platform_function_id = sa_env_pf.pf_id) " & _
"ON d_service_area.service_area_id = sa_env_pf.sa_id) " & _
"INNER JOIN comments_main " & _
"ON sa_env_pf.id = comments_main.row_id) " & _
"INNER JOIN (d_sw_type " & _
"INNER JOIN (d_software " & _
"INNER JOIN (d_hw_type " & _
"INNER JOIN (d_hardware " & _
"INNER JOIN hw_sw " & _
"ON d_hardware.hardware_id = hw_sw.hardware_id) " & _
"ON d_hw_type.hw_id = d_hardware.hw_type_id) " & _
"ON d_software.software_id = hw_sw.software_id) " & _
"ON d_sw_type.sw_id = d_software.sw_type_id) " & _
"ON sa_env_pf.id = hw_sw.row_id_ref " & _
"WHERE d_service_area.service_area = 'telephone_services' " & _
"UNION ALL " & _
"SELECT " & _
"d_service_area.service_area AS ServiceArea, " & _
"d_environment.environment AS Environment, " & _
"d_platform_function.platform_function AS Platform, " & _
"d_hw_type.hw_type AS hdwType, " & _
"d_hardware.standard AS hdwHardware, " & _
"d_hardware.config_vrsn AS hdwVersion, " & _
"d_sw_type.sw_type AS sfwType, " & _
"d_software.standard AS sfwSoftware, " & _
"d_software.config_vrsn AS sfwVersion, " & _
"hw_sw.time_frame AS tf, " & _
""" "" AS pStDate, " & _
""" "" AS aStDate, " & _
""" "" AS pDur, " & _
"2 AS cmtTyp, " & _
"comments_impl.comment_seq AS cmtSeq, " & _
"comments_impl.comment AS cmt " & _
"FROM (d_service_area " & _
"INNER JOIN (d_platform_function " & _
"INNER JOIN (d_environment " & _
"INNER JOIN sa_env_pf " & _
"ON d_environment.environment_id = sa_env_pf.env_id) " & _
"ON d_platform_function.platform_function_id = sa_env_pf.pf_id) " & _
"ON d_service_area.service_area_id = sa_env_pf.sa_id) " & _
"INNER JOIN ((d_sw_type " & _
"INNER JOIN (d_software " & _
"INNER JOIN (d_hw_type " & _
"INNER JOIN (d_hardware " & _
"INNER JOIN hw_sw " & _
"ON d_hardware.hardware_id = hw_sw.hardware_id) " & _
"ON d_hw_type.hw_id = d_hardware.hw_type_id) " & _
"ON d_software.software_id = hw_sw.software_id) " & _
"ON d_sw_type.sw_id = d_software.sw_type_id) " & _
"INNER JOIN comments_impl " & _
"ON hw_sw.id = comments_impl.row_id) " & _
"ON sa_env_pf.id = hw_sw.row_id_ref " & _
"WHERE d_service_area.service_area = 'telephone_services' " & _
"UNION ALL " & _
"SELECT " & _
"d_service_area.service_area AS ServiceArea, " & _
"d_environment.environment AS Environment, " & _
"d_platform_function.platform_function AS Platform, " & _
"d_hw_type.hw_type AS hdwType, " & _
"d_hardware.standard AS hdwHardware, " & _
"d_hardware.config_vrsn AS hdwVersion, " & _
"d_sw_type.sw_type AS sfwType, " & _
"d_software.standard AS sfwSoftware, " & _
"d_software.config_vrsn AS sfwVersion, " & _
"hw_sw.time_frame AS tf, " & _
""" "" AS pStDate, " & _
""" "" AS aStDate, " & _
""" "" AS pDur, " & _
"3 AS cmtTyp, " & _
"comments_hdw.comment_seq AS cmtSeq, " & _
"comments_hdw.comment AS cmt " & _
"FROM (d_service_area " & _
"INNER JOIN (d_platform_function " & _
"INNER JOIN (d_environment " & _
"INNER JOIN sa_env_pf " & _
"ON d_environment.environment_id = sa_env_pf.env_id) " & _
"ON d_platform_function.platform_function_id = sa_env_pf.pf_id) " & _
"ON d_service_area.service_area_id = sa_env_pf.sa_id) " & _
"INNER JOIN (d_sw_type " & _
"INNER JOIN (d_software " & _
"INNER JOIN (d_hw_type " & _
"INNER JOIN ((d_hardware " & _
"INNER JOIN comments_hdw " & _
"ON d_hardware.hardware_id = comments_hdw.row_id) " & _
"INNER JOIN hw_sw " & _
"ON d_hardware.hardware_id = hw_sw.hardware_id) " & _
"ON d_hw_type.hw_id = d_hardware.hw_type_id) " & _
"ON d_software.software_id = hw_sw.software_id) " & _
"ON d_sw_type.sw_id = d_software.sw_type_id) " & _
"ON sa_env_pf.id = hw_sw.row_id_ref " & _
"WHERE d_service_area.service_area = 'telephone_services' " & _
"UNION ALL SELECT " & _
"d_service_area.service_area AS ServiceArea, " & _
"d_environment.environment AS Environment, " & _
"d_platform_function.platform_function AS Platform, " & _
"d_hw_type.hw_type AS hdwType, " & _
"d_hardware.standard AS hdwHardware, " & _
"d_hardware.config_vrsn AS hdwVersion, " & _
"d_sw_type.sw_type AS sfwType, " & _
"d_software.standard AS sfwSoftware, " & _
"d_software.config_vrsn AS sfwVersion, " & _
"hw_sw.time_frame AS tf, " & _
""" "" AS pStDate, " & _
""" "" AS aStDate, " & _
""" "" AS pDur, " & _
"4 AS cmtTyp, " & _
"comments_sftw.comment_seq AS cmtSeq, " & _
"comments_sftw.comment AS cmt " & _
"FROM (d_service_area " & _
"INNER JOIN (d_platform_function " & _
"INNER JOIN (d_environment " & _
"INNER JOIN sa_env_pf " & _
"ON d_environment.environment_id = sa_env_pf.env_id) " & _
"ON d_platform_function.platform_function_id = sa_env_pf.pf_id) " & _
"ON d_service_area.service_area_id = sa_env_pf.sa_id) " & _
"INNER JOIN (d_sw_type " & _
"INNER JOIN ((d_software " & _
"INNER JOIN comments_sftw " & _
"ON d_software.software_id = comments_sftw.row_id) " & _
"INNER JOIN (d_hw_type " & _
"INNER JOIN (d_hardware " & _
"INNER JOIN hw_sw " & _
"ON d_hardware.hardware_id = hw_sw.hardware_id) " & _
"ON d_hw_type.hw_id = d_hardware.hw_type_id) " & _
"ON d_software.software_id = hw_sw.software_id) " & _
"ON d_sw_type.sw_id = d_software.sw_type_id) " & _
"ON sa_env_pf.id = hw_sw.row_id_ref " & _
"WHERE d_service_area.service_area = 'telephone_services' " & _
"ORDER BY Environment, Platform, hdwType, hdwHardware, hdwVersion, sfwType, sfwSoftware, sfwVersion, tf, cmtTyp" & ";"
***
Line 228: set xrs = dbConn.execute(sSQL)
***
While I'm busy going insane, can someone please guide me in the right direction? Thanks!
|
