[PHP] How to let PHP cgi find oracle TNS?

[Jude Chen]

I use PHP (version 4.0.3pl1) as a cgi on my IIS web server with NT4.0. But I find when I try to connect a distant Oracle database, PHP can not find the correct TNS name, quoted as followings:   Warning: Unable to connect to ORACLE (ORA-12154: TNS:could not resolve service name) in E:\website\yktest\web\includes\db\dbenv.php on line 4   But I have the correct TNS, through which I can connect to Oracle using SQL*PLUS, configured on the machine, using SQL*NET configuration tool.   I don't know why, can anyone help me?   Jude Chen