From: "Nascar" <nascar@flash.net>
Newsgroups: comp.databases.oracle.misc
References: <J58u5.12361$yG4.1216533@news1.cableinet.net>
Subject: Re: oracle/asp - no error messages?
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Message-ID: <oUsu5.805$oc3.76529@news.flash.net>
Date: Sat, 09 Sep 2000 15:43:16 GMT
NNTP-Posting-Host: 63.254.25.93
X-Complaints-To: abuse@flash.net
X-Trace: news.flash.net 968514196 63.254.25.93 (Sat, 09 Sep 2000 10:43:16 CDT)
NNTP-Posting-Date: Sat, 09 Sep 2000 10:43:16 CDT
Organization: FlashNet Communications, http://www.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@css2.com> wrote in message
news: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
>
>