Re: oracle/asp - no error messages?

From: Nascar <nascar_at_flash.net>
Date: Sat, 09 Sep 2000 15:43:16 GMT
Message-ID: <oUsu5.805$oc3.76529@news.flash.net>

Can't you use an ON ERROR construct prior to opening the queries, and then capturing the errors that occur After trying to execute the SQL?

"Russell England" <russ_at_css2.com> wrote in message news:J58u5.12361$yG4.1216533_at_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 Sat Sep 09 2000 - 10:43:16 CDT