The main reason is because you're probably NOT getting a persistent connection with IIS. I've been fighting with this problem of Oracle for so long that I finally gave up on it. I started on IIS4 but couldn't keep the server from breaking down after a couple of hours after the first login while using the ISAPI module. There are no persistent connections as CGI (obviously)... then I switched to Apache and had the same problem you're describing. The only way I was able to "fix" it was to increase the timeout on the Oracle side. But, it still doesn't keep the persistent connection open very well.
SO, I've ported the entire thing over to MySQL (luckily the databases aren't too big (5 tables, 3 tiny ones and 2 big ones (40,000 and 120,000 records each).... and will be making the transfer the first of the year. I tried a million different things. What I would mostly suggest is to use the latest php 4.0.8-dev from www.php4win.com and see if some of the changes Thies has been working on make a difference... he has made a number of changes trying to combat the Oracle on Windows nightmare but I don't think they are included in the 4.0.6 release, and whether or not they'll work I don't know. Good luck, please let me know if you have any, John --------------------- John Asendorf - [EMAIL PROTECTED] Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Nullum magnum ingenium sine mixtura dementiae fuit > -----Original Message----- > From: Jozsef Szilagyi [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 06, 2001 12:18 PM > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon > Windows 2000 Server > > > Hello ! > > I have a strange problem, with the combination of configuration on the > subject. > When want to use permanent connection to Oracle (OCIPlogon) the > oracle sessions never end, and quiclky raise the 50 limit of Oracle > procesess. > > BUT when I use on the same machine, with the same PHP, Oracle, > and the same php scripts, only i change the webserver from Apache to > IIS 5.0, the problem dissapeared. The IIS only open a very > low number of > connection > and the connection time (for the second request) is much much > small than > the same thing under Apache. > > Now my question is, where is the problem ? > Why with IIS is ok, and with Apache not ? > > SzJ. > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
