Re: oracle/asp - no error messages?

:)

Thanks. I already have that in place. It sends off the query but doesn't return any result at all. It just hangs up.

Cheers

Russ

"Nascar" <nascar_at_flash.net> wrote in message news:oUsu5.805$oc3.76529_at_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 Tue Sep 12 2000 - 06:42:19 CDT