<reply all - grin> John, might I suggest that if you are converting a database from oracle you may want to consider a database that may more closely matches your previous system.
You may be familiar with a Borland InterBase, well they have an open source descendant named 'Firebird'. You can check it out at: http://firebird.sourceforge.net/ And all of the PR material can be found at http://www.interbase.com, anything that InterBase has, Firebird has (and more). I'd suggest you give it a quick run through, it's very easy to set up, and there are several free, quite good gui interfaces. And, to top it all off... PHP 4 has full support of InterBase 6.0: http://www.php.net/manual/en/ref.ibase.php > -----Original Message----- > From: Asendorf, John [mailto:[EMAIL PROTECTED]] > Sent: December 6, 2001 10:42 > To: Jozsef Szilagyi; [EMAIL PROTECTED] > Subject: RE: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon > Windows 2000 Server > > 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] -- 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]
