#24419 [Opn->Fbk]: ifx_connect broken when connecting to remote informix server

ID: 24419 Updated by: sniper@php.net Reported By: leightonbrown at excite dot com -Status: Open +Status: Feedback Bug Type: Informix related Operating System: Windows 2000 PHP Version: 4.3.2 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-06-30 13:25:19] leightonbrown at excite dot com Description: ------------ On a remote host running several informix server instances, ifx_connect will only connect to the INFORMIXSERVER that is the default for the user and password supplied. Even when sqlhosts and etc/services are setup correctly on the local host. Environment PHP 4.3.2 Web server: Apache 2.0.46 Web server host: Windows 2000 SP 3 OS: Windows 2000 SP 3 Database: Informix OnLine Dynamic 7.3UD2R1 Database host OS: Solaris 5.8 local sqlhosts entry: mars_tcp onsoctcp remote_1 mars_tcp birch_tcp onsoctcp remote_1 birch_tcp c:\winnt\system32\drivers\etc\services entry: mars_tcp 1529/tcp birch_tcp 1527/tcp Reproduce code: --------------- // program code [line 62 in index.php] fails : $ifx_handle = ifx_connect("db1@mars_tcp", "userid", "passwd"); //program code [line 62 in index.php] succeeds : $ifx_handle = ifx_connect("db2@birch_tcp", "userid", "passwd"); //birch_tcp is the default INFORMIXSERVER for userid/password or remote_1, mars_tcp is not. Expected result: ---------------- $ifx_handle <> 0 Actual result: -------------- $ifx_handle = 0 with a logged error : PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-761] in C:\Program Files\Apache Group\Apache2\htdocs\php\index.php on line 62 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=24419&edit=1