|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24419 ifx_connect broken when connecting to remote informix server
Submitted: 2003-06-30 13:25 UTC Modified: 2003-08-18 11:43 UTC
From: leightonbrown at excite dot com Assigned:
Status: Closed Package: Informix related
PHP Version: 4.3.2 OS: Windows 2000
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: leightonbrown at excite dot com
New email:
PHP Version: OS:


 [2003-06-30 13:25 UTC] leightonbrown at excite dot com
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. 

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


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2003-08-18 11:33 UTC] leightonbrown at excite dot com
Thanks, it works with this CVS snapshot.

 [2003-08-18 11:43 UTC]
works -> closed.

PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Jun 22 06:01:31 2024 UTC