RE: Still floundering, OCIPLogon still dying after a period of ti me.. .

---------------------------------------------------------------------------- ----------------- Disclaimer: The information contained in this email is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying or disclosure is strictly prohibited. If you have received this email in error please immediately advise us by return email at postmaster@normandy.com.au and delete the email document without making a copy. ---------------------------------------------------------------------------- ----------------- John, At one client we had some issues with OCIPlogon mainly due to some crappy oracle cold backup scripts. We ended up swapping to OCILogon() and the CGI version of PHP and havent had any problems since. At the same time we also fixed the scripts so im not sure which fixed our intermittant problems. As standard we use CGI + non-persistant due to the fact that it was less risk and seperatable. All our DB queries are quite large (up to a minute) so the faster connection speed of Plogon isn't quite as valuable. That was on a un*x box, and i would say the same theory holds true for your PHP + Windows if you are using large queries. mn Mark Nold markn@enspace.com <mailto:markn@enspace.com> Senior Consultant   Change is inevitable, except from vending machines. -----Original Message----- From: Asendorf, John [mailto:JAsendorf@lcounty.com] Sent: Friday, December 01, 2000 12:11 AM To: Php-Windows (E-mail) Subject: Still floundering, OCIPLogon still dying after a period of time.. . I'm still at an impasse with OCIPLogon. I keep losing my Oracle Connection after an unknown period of inactivity (est. 1/2 hour to an hour). Are there any Oracle DBAs who might know of a reason that the connection is being dropped? Someone thinks it might be an optional parameter in the init.ora file... --------------------- 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.