RE: [PHP-WIN] PHP4 and Oracle 8.0.5/WinNT

you may need to change your logon script: I personally use the db (third) variable... OCILogon (string username, string password [, string db]) I'm not CERTAIN, but I think that since you've moved to Oracle 8, you're going to have to use the OCI functions now... as opposed to the ORA functions. --------------------- 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: Bod [mailto:bara_skrap@hotmail.com] > Sent: Thursday, November 16, 2000 10:34 AM > To: php-windows@lists.php.net > Subject: Re: [PHP-WIN] PHP4 and Oracle 8.0.5/WinNT > > > Hello John (and of course everyone else in the great world of PHP), > > thank you for your reply! The connection is a straight > forward ora_logon() as > below: > ------- > if($conn = ora_logon("logon_id@database_sid", "password")) { > /* SELECT and UPDATE stuff */ > } else { > /* act on the failed connection */ > } > ------- > Note that the above connection code worked with the PHP3! And > I can do both SQL > Plus and TNSPING toward the database in question. > > In the previous PHP3 installation I had enabled the following > extensions in > php3.ini: > extension=php3_oci73.dll > > In the new PHP4 installation (php3.ini removed) the following > are enabled in > php.ini: > extension=php_oracle.dll ; BOD > > Tried adding the extension php_oci8.dll as well, but with no > difference. > Do I need an oci73.dll for PHP4? Been looking for one but > without any luck. > > Thank you. :) Regards, bod > > > Asendorf, John wrote: > > > Hi Bod, > > > > Since I'm not a PHP guru nor an Oracle dba, my answer is > probably pretty > > stupid. But... the one thing I've noticed while using this > combination is > > that the error you're receiving (TNS names blah blah) is > almost always > > either a coding error in your PHP (check and double check > the service) or a > > TNSnames file problem. > > > > If you can hit the dB with SQL Plus, I would bet that the > problem is in the > > PHP code. > > > > If you still have some problems, hit us with some code next > time. We can > > help you much better if you do that. > > > > John > > > > --------------------- > > 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. > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >