Re: oracle/asp - no error messages?

Does the query return in a timely fashion inside of SQL*Plus (or another query tool to go directly against the database)? You should CAPTURE the exact statement by dumping it in your ASP page.

Russell England <russ_at_css2.com> wrote in message news:vEov5.4978$%g3.288661_at_news1.cableinet.net...
> :)
>
> 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 Wed Sep 13 2000 - 07:36:07 CDT