#25206 [Csd->Bgs]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
| From: | sniper@php.net | Date: | Sat, 23 Aug 2003 00:32:53 +0000 |
| Subject: | #25206 [Csd->Bgs]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-46511@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: Closed
+Status: Bogus
Bug Type: Informix related
Operating System: Linux8.0
PHP Version: 4.3.2
New Comment:
..
Previous Comments:
------------------------------------------------------------------------
[2003-08-22 18:28:46] 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..
------------------------------------------------------------------------
[2003-08-22 08:36:34] 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 06:42:18] 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 06:08:41] 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 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