PHP4 / WinNT 4 / Oracle 7.3 via ODBC
| From: | Carlos Correa Goncalves | Date: | Fri, 19 Jan 2001 15:53:09 +0000 |
| Subject: | PHP4 / WinNT 4 / Oracle 7.3 via ODBC | ||
| Groups: | php.db php.windows | ||
| Request: | Send a blank email to php-db+get-5986@lists.php.net to get a copy of this message | ||
Hi,
I´m using PHP 4.0.4pl1 with extension php_oracle.dll, Oracle client 7.3 with
the following products installed:
-------------------------
Call Interface 7.3.4.0.0
Objects for OLE 2.2.1.0.0
32 bit ODBC 2.5.3.1.0B
Support files 7.3.4.0.0
SQL*Net Client 2.3.4.0.0
... and others
------------------------------
I´m trying to connect to an Oracle 7.3 database with ODBC functions or
direct connection. Those are the code:
---------------
putenv("ORACLE_SID=badm");
putenv("ORACLE_HOME=C:\ORANT");
putenv("TNS_ADMIN=C:\ORANT\NETWORK\ADMIN");
$connect = ora_logon("usercons@badm","sylkds");
----------------
putenv("ORACLE_SID=badm");
putenv("ORACLE_HOME=C:\ORANT");
putenv("TNS_ADMIN=C:\ORANT\NETWORK\ADMIN");
$connect = odbc_connect("badm" ,"consulta","consulta");
---------------
Both are returning the following message from PHP:
Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service
name in oracle.php on line xxx
Any suggestion?