[PHP-DB] PHP & ODBC problem with ORACLE From: Emmanuel Plovier (eplovier <email protected>)
Date: 11/13/00

Hi there,

I am desperatly trying to run PHP scipt whith Oracle using ODBC.

I downloaded ODBC 8062 from Oracle, and configure it properly (i think). Indeed when using ODBCtst there is no problem connecting to the database.

I then wrote this simple scipt in PHP to test the connection:

        // create an ODBC connection, returned in $cnx
        $cnx = odbc_connect( 'DB' , 'USER', 'PASS' );
 

        if( ! $cnx ) {
                Error_handler( "Error in odbc_connect" , $cnx );
        }

and get persistently the error :

Warning: SQL error: [Oracle][ODBC][Ora]ORA-12154: ORA-12154: TNS:could not resolve
service name

I then put the TNS_ADMIN "C:\Program Files\Orant\Network\Admin" in the apache httpconf and got exactly the same error. I found articles about this problem but does someone have the solution ?

Thanks in advance.

Emmanuel

_________________________________________s_p_r_a_y_
Internet commence ici!
Choisissez vous aussi l’e-mail et l’Internet gratuits sur http://www.spray.fr 

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