ID: 25206
User updated by: jkshin at naver dot com
Reported By: jkshin at naver dot com
-Status: Feedback
+Status: Closed
Bug Type: Informix related
Operating System: Linux8.0
PHP Version: 4.3.2
New Comment:

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..


Previous Comments:
------------------------------------------------------------------------

[2003-08-22 08:36:34] [email]sniperphp.net[/email]

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..
[url]http://snaps.php.net/php4-STABLE-latest.tar.gz[/url]

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] [email]sniperphp.net[/email]

Please try using this CVS snapshot:

[url]http://snaps.php.net/php4-STABLE-latest.tar.gz[/url]

For Windows:

[url]http://snaps.php.net/win32/php4-win32-STABLE-latest.zip[/url]



------------------------------------------------------------------------

[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 [url]http://bugs.php.net/?id=25206&edit=1[/url]