Re: Oracle logging on and off

Hi John, are you running on W2K or Window NT. On W2K I noticed that if a Persistent Connection stays idle for some time (I have not figured out the exact time yet) it seems to get terminated. Florian "Asendorf, John" schrieb: > > Hi Florian, > > I'm running ISAPI. It works fine with OCILogon. Actually it works fine > with OCIPLogon, FOR A WHILE. Then it dies... > > Maybe I need to start looking at the Oracle server... > > --------------------- > Founder of > The 'What Kind of Idiot Uses PHP with IIS with Oracle on NT?' Consortium > > Members: John Asendorf, Thomas Kryger, Florian Clever, Ron Woods, Bod > > John Asendorf - jasendorf@lcounty.com > Web Applications Developer > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > Licking County, Ohio, USA > 740-349-3631 > > Caesar si viveret, ad remum dareris. > > > -----Original Message----- > > From: Florian Clever [mailto:clever@ukl.uni-freiburg.de] > > Sent: Monday, November 20, 2000 1:51 AM > > To: JAsendorf@lcounty.com; php-windows@lists.php.net > > Subject: Oracle logging on and off > > > > > > Hi, > > > > I believe I am using the same code and it works (until you restart > > Oracle, because then PHP ISAPI would need to reconnect). > > Are you sure it has something todo with OCIPLogon. Just replace the > > OCIPLogon with OCILogon and see if you get the same error. > > > > PS: Are you running CGI or ISAPI? > > > > Florian > > > > >I'm trying to use a persistent logon with Oracle and keep > > coming up with > > >problems... > > > > > >I think it has something to do with when I'm logging on and off... > > > > > >I have a form/search page that looks somthing like this: > > > > > >OCIPLogon () > > > > > >if ( form is set) { do some searching > > >return the results > > >OCIlogoff () } > > > > > >else {form is not set > > >echo a form to fill out that returns to this page} > > > > > >Am I causing myself a problem by having the OCIPLogon where I do? > > > > > > -- > > > > Florian Clever > > > > fc@clever-soft.com > > http://www.Clever-Software-Solutions.de/ > > > > PGP Key @ ldap://certserver.pgp.net/ > > > > A computer's attention span is as long as it's power cord. > > -- Florian Clever fc@clever-soft.com http://www.Clever-Software-Solutions.de/ PGP Key @ ldap://certserver.pgp.net/ * George Orwell was an optimist. *