#25206 [Opn->Fbk]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
| From: | sniper@php.net | Date: | Fri, 22 Aug 2003 11:08:42 +0000 |
| Subject: | #25206 [Opn->Fbk]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-46480@lists.php.net to get a copy of this message | ||
ID: 25206
Updated by: sniper@php.net
Reported By: jkshin at naver dot com
-Status: Open
+Status: Feedback
Bug Type: Informix related
Operating System: Linux8.0
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-08-22 04:19:30] 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
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25206&edit=1