[PHP-INST] Problems connecting to Oracle using ODBC on an NT server From: Mark Lutze (malut <email protected>)
Date: 06/30/00

Hello,

I am looking for any suggestions on connecting to Oracle (7.3) with PHP
running on an NT 4.0 SP5 /IIS V4 server. I have PHP 4 installed and
configured to run as CGI.

If given a choice I would rather not use ODBC but since the Oracle modules
do not come with the NT install, and I do not have access to a C compiler, I
expect that ODBC is my next option. (Though is the Oracle module built and
available someplace?)

Anyway when I attempt to connect through ODBC to Oracle I get the following
error:

Warning: SQL error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154:
TNS:could not resolve service name, SQL state 08001 in SQLConnect in
F:\Inetpub\wwwroot\php\db_test2.php on line 7

I am able to TNSPING, as well as connect to the database using SQL*Plus. In
addition I am able to connect to the database using ODBC, with Oracle's ODBC
test tool, as well as using Access. I have tried using both Oracle's ODBC
driver (V 2.5 as well as Microsoft's ODBC driver (2.573).

Any help on this matter would be greatly appreciated.

Thanks,

Mark Lutze 

-- 
PHP Install Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-install-unsubscribe <email protected>
For additional commands, e-mail: php-install-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>