php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #25206 ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
Submitted: 2003-08-22 04:19 UTC Modified: 2003-08-22 19:32 UTC
From: jkshin at naver dot com Assigned:
Status: Not a bug Package: Informix related
PHP Version: 4.3.2 OS: Linux8.0
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2003-08-22 04:19 UTC] jkshin at naver dot com 
Description:
------------
RedHat8.0 + php-4.3.2 + apache_1.3.20 + informix7.3.0


informix user can dbaccess.



please help me !!

Reproduce code:
---------------
<html>
<?php
$database = "test";
$host = "db";
$user = "informix";
$pass = "informix";
if (!$connect_id = ifx_connect("$database@$host", $user, $pass)) {
echo "Unable to connect to Informix Database\n";
exit();
}
$sql = "select customer, quantity from order";
$result = ifx_query($sql, $connect_id) or die ("couldn't execute the query"); 
?>
<table>
<tr>
<?php
   while ($row = ifx_fetch_row($result)) {    
echo "<td>".$row['customer']."</td>";
echo "<td>".$row['quantity']."</td>\n";
  }
ifx_free_result($result);
ifx_close($connect_id);
?>
</tr>
</table>
</html>

Expected result:
----------------
Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461] in /usr/local/apache/htdocs/aaa.php3 on line 7

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-08-22 06:08 UTC] sniper@php.net 
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
 [2003-08-22 06:42 UTC] jkshin at naver dot com 
i did download and compile.. http://snaps.php.net/php4-STABLE-latest.tar.gz

but, error ~!!

i dont't know. why happen error code ..


Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-952] in /usr/local/apache/htdocs/test3.php3 on line 7
Unable to connect to Informix Database
 [2003-08-22 08:36 UTC] sniper@php.net 
Have you setup all the necessary environment variables in your system? (the informix related ones)
Are you really sure this is a bug in PHP..?
 [2003-08-22 18:28 UTC] jkshin at naver dot com 
i don'k know Informix DB well.
and i ask informix call center support first.

i will setup all the necessary environment variables in system first.

In the meantime, thank you for your support..
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 25 09:01:29 2024 UTC