Re: ora 12154 tns problems

Hello Laurent I had a same problem. I resolved it following the proposal by Andy Hoffman. The only difference is that I didn't have to set item 2) ... MUST use Oracle Client 8.1.6 otherweise it didn't worked in my computer. Oracle: http://otn.oracle.com/software/ Have a try. Greetings ... Nol >>>>>From Andy Hoffmann: Just the quick overview :) 1) Make sure you're using Oracle Client 8.1.6 with oci8 extension. 2) Add ONLY the ORACLE_HOME and TNS_ADMIN environment variables to your Apache httpd.conf file... like this: SetEnv ORACLE_HOME "c:/oracle/ora81" SetEnv TNS_ADMIN "c:/oracle/ora81/network/admin" These need to reflect your local directory structure, of course. All other env vars shouldn't be necessary within Apache/PHP 3) Make sure you define your Oracle Database instance within Net8 Assistant using Oracle 8.0 naming compatibility (basically, you should use SID naming, not the new "Service Name" convention) 4) When calling OCILogon, use the following call-convention: $conn = ocilogon("<my_username>","<my_password>","<my_sid>"); There are some other intricasies which may be necessary, but those are the basics to try. Let us know what happens. -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com ----- Original Message ----- From: "Laurent GARCIA" <LGarcia@ch-avignon.fr> To: <php-windows@lists.php.net> Sent: Thursday, December 14, 2000 2:42 PM Subject: [PHP-WIN] ora 12154 tns problems ** Top Secret ** ** High Priority ** i have windows2000 server, iis5.0, oracle client 8.0.5 and php 4.0.3pl1 i have oci8 and oracle installed i can access to oracle by sqlplus and sqlnet tnsnames.ora is ok sqlnet.ora is ok when i do phpinfo() , coi8, oracle installed but i have this error Warning: _oci_open_server: ORA-12154: TNS:l'adresse symbolique n'a pas pu être résolue in includes/php-dbi.inc on line 50 Error connecting to database: Unknown error thanx for your help because i don't know why i may do now? salutations distinguees laurent Garcia -- 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