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.Cate goryID = Courses.Categor yID WHERE (Index=" & request.Form("C ourseID") & ") ORDER BY Index"
'PARAMETERS Input_crse_cd Text, Input_crse_rev_ cd Text
SQL = "SELECT ref_material_te xt.ref_text, crse.days_in_cl ass "
SQL = SQL & "FROM crse, ref_material, ref_material_te xt "
SQL = SQL & "WHERE crse.crse_cd='" & request.Form("c rse_cd") & "' "
SQL = SQL & "AND crse.crse_rev_c d = '" & request.Form("c rse_rev_cd") & "' "
SQL = SQL & "AND crse.crse_overv iew_cd = ref_material.re f_cd "
SQL = SQL & "AND ref_material.re f_cd = ref_material_te xt.ref_cd "
SQL = SQL & "AND crse.crse_overv iew_rev_cd = ref_material.re f_rev_cd "
SQL = SQL & "AND ref_material.re f_rev_cd = ref_material_te xt.ref_rev_cd"
'Set up the database connection object.
set conn = server.createob ject("ADODB.Con nection")
'Open the connection to the DSN which exists on the server.
conn.open Session("sessCo nnectionString" )
'Execute the SQL statement, the result is a recordset put into 'theData'.
set theData=conn.ex ecute(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.Cate goryID = Courses.Categor yID WHERE (Index=" & request.Form("C ourseID") & ") ORDER BY Index"
'PARAMETERS Input_crse_cd Text, Input_crse_rev_ cd Text
SQL = "SELECT ref_material_te xt.ref_text, crse.days_in_cl ass "
SQL = SQL & "FROM crse, ref_material, ref_material_te xt "
SQL = SQL & "WHERE crse.crse_cd='" & request.Form("c rse_cd") & "' "
SQL = SQL & "AND crse.crse_rev_c d = '" & request.Form("c rse_rev_cd") & "' "
SQL = SQL & "AND crse.crse_overv iew_cd = ref_material.re f_cd "
SQL = SQL & "AND ref_material.re f_cd = ref_material_te xt.ref_cd "
SQL = SQL & "AND crse.crse_overv iew_rev_cd = ref_material.re f_rev_cd "
SQL = SQL & "AND ref_material.re f_rev_cd = ref_material_te xt.ref_rev_cd"
'Set up the database connection object.
set conn = server.createob ject("ADODB.Con nection")
'Open the connection to the DSN which exists on the server.
conn.open Session("sessCo nnectionString" )
'Execute the SQL statement, the result is a recordset put into 'theData'.
set theData=conn.ex ecute(SQL) <-----This is line 23
theColor="white "
%>
If anyone has any ideas please help
Comment