Unknown Runtime Error

[FontanaS]

I keep getting the following error

Microsoft VBScript runtime error '800a0bb9'
Unknown runtime error
/nats/tocancel.asp, line 99

Line 99 Is -
SET NATSdb = Server.CreateObject("ADODB.Connection&quot
NATSdb.Open Session("NATS_ConnectionString&quot
Cmd="SELECT * FROM tTravelorders Where trvauthnbr='" & trim(session("tonbr&quot) & "'"
Response.Write (&quot;Cmd Is: &quot;&Cmd&&quot;<br>&quot
SET RSdatabase=Server.CreateObject(&quot;ADODB.Recordset&quot
RSdatabase.Open Cmd,NATSdb,adOpenKeyset,adLockReadonly

The Response Write Reads -
SELECT * FROM tTravelorders Where trvauthnbr='03FAMC0007G'


Any suggestions?
I have connection problems with the server, I figured if it was a connection problem that I would get an ODBC error.

Also, the record does exist in the table.

THANKS!

 

[krisbrixon]

First question, have you ever had an ADO connection work? If so, then what is different?

Maybe try this:

Set NATSdb = Server.CreateObject(&quot;ADODB.Connection&quot
Set RSdatabase = Server.CreateObject(&quot;ADODB.Recordset&quot
NATSdb.Open Session(&quot;NATS_ConnectionString&quot

Cmd=&quot;SELECT * FROM tTravelorders Where trvauthnbr='&quot; & trim(session(&quot;tonbr&quot) & &quot;'&quot;
Response.Write (&quot;Cmd Is: &quot;&Cmd&&quot;<br>&quot
Set RSdatabase = NATSdb.Execute(strSQL)


Kris
- The opulence of the front office decor varies inversely with the fundamental solvency of the firm.