Actually, I'm using the ADODB class, so eventually I would be able to switch to any database that is supported by it. So, Robin, what are you? A sales rep for Borland or something ;)?
--------------------- 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: Robin Bolton [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 07, 2001 2:55 AM > To: 'Asendorf, John'; [EMAIL PROTECTED] > Subject: RE: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon > Windows 2000 Server > > > <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]
