RE: Oracle logging on and off

I'm on WinNT... I think I've got a new avenue to try, our web server sits in a DMZ outside of the firewall. I'm thinking that perhaps the firewall is shutting down the port after so much idle time? Whadaya think? --------------------- 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 8:25 AM > To: Asendorf, John > Cc: php-windows@lists.php.net > Subject: 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. * >