Win98/2000/PHP4/Apache/Oracle8 connect problem

[Anon]

Aaaargh!

Ocilogon gives:
_oci_open_server: ORA-12154: TNS:could not resolve service name

Just Oracle on a remote machine. tnsnames.ora looks fine, sqlplus, toad & tnsping work.

Tried it with:
putenv("ORACLE_SID=DB");
putenv("ORACLE_HOME=c:\Oracle\Ora81");

One thing from installation (got it from http://www.phpuser.com/download/files/php-distributions/PHP_Release_4.0.0_win32_binary_build_23.05.00.zip) I don't understand:
"For using php_oci8.dll you must have oci.dll from distribution."

It's not included?!?

Any help is greatly appreciated!

[Anon]

Try putting the tnsnames.ora file into the same directory as the php file you are running. This worked for me, but on Solaris 2.5.1.
On my windows machine with php I didn't have to do that, but its worth a shot.

[Anon]

Same hell for me, but I can get a "slightly better error" by doing this :

$dbcnn = ocilogon("scott@database", "tiger");

rather than

$dbcnn = ocilogon("scott", "tiger", "database");

I obtain

ORA-12203: TNS:unable to connect to destination

which means that at least the tnsnames.ora file is reached.

ok, it doesn't work... but it is maybe a step forward ?