#22971 [Fbk->NoF]: Error in odbc_prepare or in odbc_connect?

ID: 22971 Updated by: sniper@php.net Reported By: anton at esrr dot ru -Status: Feedback +Status: No Feedback Bug Type: ODBC related Operating System: Linux RedHat 8 PHP Version: 4.3.1 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2003-04-03 06:31:53] kalowsky@php.net Sniper, the real fix would be not to use the native interface to IBM DB2 and to use unixODBC as per the DB2 recommendations. Unfortunately I haven't a DB2 machine to test with and cannot comment much more on that. What I do know is that DB2 doesn't like the SQL_CURSOR_DYNAMIC that is used by PHP, and in fact claims it's leaking memeory. Removing the EXTENDED_FETCH will discontinue the cursor use, but this is also why I suggested changing the cursor. ------------------------------------------------------------------------ [2003-04-03 04:57:35] sniper@php.net Dan: Would the real fix be to disable that HAVE_SQL_EXTENDED_FETCH for DB2 altogether? ------------------------------------------------------------------------ [2003-04-02 20:07:47] anton at esrr dot ru >You had the correct category before, IBMs DB2 uses ODBC. > >Try calling odbc_set_option and changing your CURSOR to >SQL_CURSOR_FORWARD_ONLY, this should fix a few things for >your DB2 >install. Ok. I'll try. Thank you. But on this moment the positive result has achieved by commenting out strings containing #define HAVE_SQL_EXTENDED_FETCH 1 in php_odbc_includes.h, as described in Bug #9869 (http://bugs.php.net/bug.php?id=9869). I commented out all lines with this string, but I think that DB2 CLI part enough. ------------------------------------------------------------------------ [2003-04-02 18:41:43] kalowsky@php.net You had the correct category before, IBMs DB2 uses ODBC. Try calling odbc_set_option and changing your CURSOR to SQL_CURSOR_FORWARD_ONLY, this should fix a few things for your DB2 install. ------------------------------------------------------------------------ [2003-04-02 18:23:48] anton at esrr dot ru . ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/22971 -- Edit this bug report at http://bugs.php.net/?id=22971&edit=1