Connection problem between Oracle and PHP4 ...

Hello,

My configuration is :
Windows 2000
Oracle 8.1.6
Apache 1.3.12
PHP 4.0.3pl1

My script is good with php3, but not with php4.
i have this warning :

Warning: _oci_open_server: ORA-12154: TNS:l'adresse symbolique n'a pas pu être résolue in ../../../libs/db_lib.php on line 17

ocilogon(stage_master,oracle,ispb)

Could someone help me ?

thanks.

Maybe you could translate the error for the 15.9 billion people who don't speak french? :-)

of course ...

the error message is :

Warning: _oci_open_server: ORA-12154: TNS:the symbolic adress can't be resolved in ../../../libs/db_lib.php on line 17

ocilogon(stage_master,oracle,ispb)

i think that the oci oracle dll can't access to the tnsnames.ora file ...

sorry ...

I get a similar problem, mine is just in English 😉

Using PHP 4.0.3 I cannot seem to connect to a remote Oracle dB using the OCI 7 calls e.g.

The connect string

$conn = Ora_Logon("scott", "tiger");

connects fine to the local dB on the NT web server, but I get the error

Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in E:\apache\htdocs\php3\oraremote.php3 on line 18

when I use a connect string such as

$conn = Ora_Logon("scott@somedb","tiger");

I get a similar error when I try and connect to an Oracle dB via ODBC.

All these work 100% using PHP 3.0.16, and with PHP 4.0.3 the ODBC connections to Access and MS SQL server and the OCI8 stuff works fine.

It seems asif it can't get hold of the "tnsnames.ora" file, as suggested by Sylvain.

Nick