ID: 25206 Updated by: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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("[EMAIL PROTECTED]", $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
