ODBC Connection To ORACLE
| From: | Ron Woods | Date: | Mon, 11 Sep 2000 20:23:30 +0000 |
| Subject: | ODBC Connection To ORACLE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2805@lists.php.net to get a copy of this message | ||
I'm running PHP on a WinNT and Netscape Server using the CGI version of php.
So far I'm unable to make an ODBC connection to our Oracle DB using the
Oracle ODBC 73 or 73.2.5 drivers or the MS Oracle driver.
Using the MS driver I receive the error "Warning: SQL error:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve
service name, SQL state 08001 in SQLConnect"
Using the Oracle 73.2.5 driver I receive the error "Warning: SQL error:
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:could not resolve
service name., SQL state S1000 in SQLConnect".
Using the Oracle 73 driver I receive the error "Warning: SQL error:
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:could not resolve
service name., SQL state S1000 in SQLConnect".
I am setting (putenv()) the ORACLE_HOME, ORACLE_SID, and TNS_ADMIN variables
before issuing the connection. Can anyone point me in the right direction?
Thanks,
Ron Woods
rwoodsathome@yahoo.com