ASP Error message - Need fast Help Please

[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

[Crouchie1998]

Mr Conway!

We finally meet. What's it like to be a SPAMMER? I've reported many of SPAM from QWEST to SPAM COP, ROKSO, SBL, SPAMHAUS etc. You are one of the reasons I took up fighting SPAM as a hobby & the second I receive your SPAM messages I report them to the above named SPAM databases.

NEVER IN A MILLION YEARS WOULD I EVER HELP YOU!!

DO NOT HELP THIS PERSON BECAUSE IT'S PROBABLY FOR A SPAMVERTISIED WEBSITE!!!!!!!!!!!!!!!

The good thing now is I have your e-mail address.

Crouchie1998
BA (HONS) MCP MCSE

[Brian Conway]

I'm not sure who you are, but please don't post messages like this when I am trying to get help, as obviously you are wrong.

Thank you
"Crouchie1998" <cr**********@spamcop.net> wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl...
Mr Conway!

We finally meet. What's it like to be a SPAMMER? I've reported many of SPAM from QWEST to SPAM COP, ROKSO, SBL, SPAMHAUS etc. You are one of the reasons I took up fighting SPAM as a hobby & the second I receive your SPAM messages I report them to the above named SPAM databases.

NEVER IN A MILLION YEARS WOULD I EVER HELP YOU!!

DO NOT HELP THIS PERSON BECAUSE IT'S PROBABLY FOR A SPAMVERTISIED WEBSITE!!!!!!!!!!!!!!!

The good thing now is I have your e-mail address.

Crouchie1998
BA (HONS) MCP MCSE

[Brian Conway]

Well, after hours of trying to figure this out yesterday, it turns out that it was switching from an ODBC driver to a native driver that resolved the issue.
"Brian Conway" <Br**********@qwest.com> wrote in message news:e5*************@TK2MSFTNGP14.phx.gbl...
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

[Crouchie1998]

Is this not you:

Registrant:
Qwest Communications International Inc.
555 17TH ST
DENVER, CO 80202-5555
US
Phone: [phone]


Crouchie1998
BA (HONS) MCP MCSE

[Cor Ligthert]

Crouchie,

For me this looks as a normal internet provider which has an email servers.
http://www.qwest.com/

Can your spammer not be somebody who uses smtp that even maybe you or I
provided the method to how to use that from that provider?

;-)

Cor

[Cor Ligthert]

Brian,

Your question is miles beside this newsgroup.
It is classic ASP
It is Adodb (vb.data)
It is VBS

In one of the newsgroups about that, you will maybe get help.
For most active in this newsgroup is that already long behind us so needs to
go back in time.

Maybe you can find a newsgroup accoording to the names I gave you or even
with a combination of those.

When you want a first start you can try first

microsoft.public.scripting.vbscript

I hope this helps,

Cor

[Crouchie1998]

No, it always reverse back to that address