Bug #18491 Updated: Oracle/ODBC connection under PHP 4.2.1

ID: 18491 Updated by: frederic.puteaux@chello.fr Reported By: frederic.puteaux@chello.fr Status: Open Bug Type: ODBC related Operating System: Windows 2000 PHP Version: 4.2.1 New Comment: PHP is running under Microsoft IIS. Previous Comments: ------------------------------------------------------------------------ [2002-07-23 09:32:25] frederic.puteaux@chello.fr This is test page works with PHP and MySQL, but doesn't work with Oracle 8 and PHP4. The Oracle configuration is OK. The ODBC configuration is OK. <? $myConn = odbc_connect("MyDSN","MyUser","MyPassword",SQL_CUR_DEFAULT); ?> Warning: SQL error: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name, SQL state 08001 in SQLConnect in c:\web\cgi\gias\testoracle.php on line 3 I have the same message if i use ADO or if i use a Direct Oracle connection with ora_logon. All programs of Oracle, same as SQL*Plus run without problem. Oracle Version : 8.0.5 Oracle Client Software Version : 8.0.5 PHP version : 4.2.1 Windows version : 5.0.2195 SP2 Oracle ODBC Driver : 8.0.5 I can't use the oci. I have this message : Unable to load dynamic library : c:/php/extensions/php_oci8.dll - La procédure spécifiée est introuvable. (don't find the specified procedure) All others libraries can be loaded without problem. Sorry for my english. Fred. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18491&edit=1