How to let PHP cgi find oracle TNS?
| From: | Jude Chen | Date: | Fri, 11 May 2001 04:07:15 +0000 |
| Subject: | How to let PHP cgi find oracle TNS? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-52400@lists.php.net to get a copy of this message | ||
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?