oracle/asp - no error messages?

From: Russell England <russ_at_css2.com>
Date: Fri, 08 Sep 2000 16:03:53 GMT
Message-ID: <J58u5.12361$yG4.1216533@news1.cableinet.net>

I have an ODBC connection called Ora7 and I use the following connection string for Oracle 7.3 in ASP:

"data source=Ora7;dbq=2:;userid=" & strUserID & ";Password=" & strPassword &
";"

But if an error occurs in a query, no error messages are displayed and the page waits for the script timeout. Then if I try to access any asp pages in the web, nothing happens. I've tried stopping and starting web services but still nothing. I have to restart the computer for the asp pages to start working again?

Some of the errors are deliberate, eg: integrity violations, so I really need it to tell me whats going on.

I am using NT4 with SP6 and the NT 4.0 option pack.

Any ideas would be much appreciated.

Cheers

Russ Received on Fri Sep 08 2000 - 11:03:53 CDT