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

I have the same problem without ODBC, using PHP4 and Oracle 8.0.5.1
client/Apache on Linux.

I can't connect using the same account/tnsname as it works with sqlplus.

error msg is:

Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service
name in /home/nn/nn/php/ora.php on line 9

Andreas

>
>
> 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>
>
> 

-- 
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>