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

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. > -----Original Message----- > From: Bod [mailto:bara_skrap@hotmail.com] > Sent: Thursday, November 16, 2000 9:08 AM > To: php-windows@lists.php.net > Subject: [PHP-WIN] PHP4 and Oracle 8.0.5/WinNT > > > Hello! > > I guess I should apply to join the "What Kind of Idiot Uses > PHP with IIS > with Oracle on NT?" consortium... but I must! Coding PHP feels much > better then coding ASP, and the code will be moved to a HP-UX machine, > so no ASP! This beside the fact that it feels good. :) > > The machine situation is a Windows NT 4 server with IIS 4, and the > server is running an Oracle 8.0.5 database. > > PHP3 had no problems connecting to the database, nor had it > any problems > connecting to external databases. PHP4, enter the scene. No more > connections. Always the good old "TNS:could not resolve service name". > I've browsed through all the messages in here, and everything point on > one thing - upgrade to Oracle 8.1.6. And this will be a problem... I > need to stay on Oracle 8.0.5 as that will be the situation once the > application is put in production. > > I installed the 8.1.6 client separately, but the system is not to fond > of this, and as I am still getting the same error from my attempted > connection (using ora_logon) I belive that the 8.0.5 system is still > being used by PHP. > > Anyone? What is the situation with PHP4 and connecting through 8.0.x > clients and even old 7.3.4 clients? > > In advance, thank you. > > Bod, Sweden > bara_skrap@hotmail.com > > > > -- > 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 >