B
Brian Conway
I am having problems with an ASP page that refuses to run. I have eliminated some of the other errors that I was receiving on it which were permission problems. However, now I get the following
Error Type:
Provider (0x80004005)
Unspecified error
/TEDS/details.asp, line 23
I am assuming this is generic and have no idea where to look for this problem. The section that is involved with this only contains the following
<%
'Build the SQL statement to select data from the database.
'SQL = "SELECT Courses.*, Categories.Name FROM Categories INNER JOIN Courses ON Categories.CategoryID = Courses.CategoryID WHERE (Index=" & request.Form("CourseID") & ") ORDER BY Index"
'PARAMETERS Input_crse_cd Text, Input_crse_rev_cd Text
SQL = "SELECT ref_material_text.ref_text, crse.days_in_class "
SQL = SQL & "FROM crse, ref_material, ref_material_text "
SQL = SQL & "WHERE crse.crse_cd='" & request.Form("crse_cd") & "' "
SQL = SQL & "AND crse.crse_rev_cd = '" & request.Form("crse_rev_cd") & "' "
SQL = SQL & "AND crse.crse_overview_cd = ref_material.ref_cd "
SQL = SQL & "AND ref_material.ref_cd = ref_material_text.ref_cd "
SQL = SQL & "AND crse.crse_overview_rev_cd = ref_material.ref_rev_cd "
SQL = SQL & "AND ref_material.ref_rev_cd = ref_material_text.ref_rev_cd"
'Set up the database connection object.
set conn = server.createobject("ADODB.Connection")
'Open the connection to the DSN which exists on the server.
conn.open Session("sessConnectionString")
'Execute the SQL statement, the result is a recordset put into 'theData'.
set theData=conn.execute(SQL) <-----This is line 23
theColor="white"
%>
If anyone has any ideas please help
Error Type:
Provider (0x80004005)
Unspecified error
/TEDS/details.asp, line 23
I am assuming this is generic and have no idea where to look for this problem. The section that is involved with this only contains the following
<%
'Build the SQL statement to select data from the database.
'SQL = "SELECT Courses.*, Categories.Name FROM Categories INNER JOIN Courses ON Categories.CategoryID = Courses.CategoryID WHERE (Index=" & request.Form("CourseID") & ") ORDER BY Index"
'PARAMETERS Input_crse_cd Text, Input_crse_rev_cd Text
SQL = "SELECT ref_material_text.ref_text, crse.days_in_class "
SQL = SQL & "FROM crse, ref_material, ref_material_text "
SQL = SQL & "WHERE crse.crse_cd='" & request.Form("crse_cd") & "' "
SQL = SQL & "AND crse.crse_rev_cd = '" & request.Form("crse_rev_cd") & "' "
SQL = SQL & "AND crse.crse_overview_cd = ref_material.ref_cd "
SQL = SQL & "AND ref_material.ref_cd = ref_material_text.ref_cd "
SQL = SQL & "AND crse.crse_overview_rev_cd = ref_material.ref_rev_cd "
SQL = SQL & "AND ref_material.ref_rev_cd = ref_material_text.ref_rev_cd"
'Set up the database connection object.
set conn = server.createobject("ADODB.Connection")
'Open the connection to the DSN which exists on the server.
conn.open Session("sessConnectionString")
'Execute the SQL statement, the result is a recordset put into 'theData'.
set theData=conn.execute(SQL) <-----This is line 23
theColor="white"
%>
If anyone has any ideas please help