From: [EMAIL PROTECTED] Operating system: SunSolaris 8 Sparc PHP version: 4.1.1 PHP Bug Type: Informix related Bug description: Multiple Connections not allowed
Hi, I would like to report a bug in the Informix module of PHP 4.1.1. When you try to use more than one connection, the last connection created is the one that receives every statement, and under this circumstances you may get a SQLCODE error code -206 when calling ifx_query as the table may not exist in the current database. I was debugging the Informix implementation and I found that in the function ifx_query the following statement is missing: EXEC SQL set connection :ifx; before the call of the macro PHP_IFX_CHECK_CONNECTION and the call to the PREPARE statement. If you add that statement, the funcion ifx_query works fine. This function call is needed as every time that you execute the statement CONNECT TO ... that connection is the active one and the former connections become dormant. When you want to use one of those connection, you need to active it again using the statement SET CONNECTION. I hope this helps. -- Edit bug report at http://bugs.php.net/?id=15628&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=15628&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=15628&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=15628&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=15628&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=15628&r=support Expected behavior: http://bugs.php.net/fix.php?id=15628&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=15628&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=15628&r=submittedtwice