Re: ASP stops responding with Oracle

Found it, courtesy of Jonathan Lewis:
<quote>
dbms_system.ksdwrt(2,'A line of text');

Will write the text to the alert log.
Use 1 instead of 2 to write to the trace file Use 3 to write to both.

Works from about 7.3 onwards - can't
remember exact versions

</quote>

--
Frank
frank <fbortel_at_home.nl> schreef in berichtnieuws 39FC78D9.A330339_at_home.nl...


> Niall,

>

> you can wite to the alert log file - has been in a thread

> somewhere. Can't recall where, but I seem to have saved it

> somewhere. Probably at work.

> In the mean time, search archives - I'm almost sure

> it was here.

>

> Grtz, Frank

>

> Niall Litchfield wrote:

>

> > Hi

> > do you get any error messages in either the NT event log on the web

 server


> > or the oracle alert log

> >

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > "Anders" <anders_at_dreamteam.net> wrote in message

> > news:39E41F5D.2B6F540F_at_dreamteam.net...

> > > Anders wrote:

> > > >

> > > > Hi!

> > > >

> > > > I'm porting a web application from MS SQL Server til Oracle 8i.

> > > >

> > > > The problem is that ASP stops responding after a while, this does

> > > > not happen when I use SQL server as a data source.

> > > >

> > > > I've tried to download the latest Oracle driver, but I'm not

> > > > sure how to install it. I need the Oracle Universal Installer,

> > > > but I can't find it...

> > >

> > > I managed to find the Oracle Universal Installer, but

> > > installing the latest ODBC driver did not fix the problem...

> > >

> > > Anders

>