Bug #15199 Updated: Random SQLExecDirect error

ID: 15199 User updated by: serge@globalbeach.com Reported By: serge@globalbeach.com Old Status: Open Status: Closed Bug Type: ODBC related Operating System: RH 7.2 / 2.4.17 PHP Version: 4.1.1 New Comment: Me Again. It seems that this issue has been discussed on the OOB news group. Apparently one should not use odbc_pconnect with the ODBC-ODBC bridge because OOB server can time out the connection and then PHP is left with a dead connection without knowing it. I am doing some more testing by setting the timeout value of the OOB server to 0 (don’t time out connections) and leaving pconnect. If this does not work then I will set the timeout value to 3600 and use odbc_connect. Serge Previous Comments: ------------------------------------------------------------------------ [2002-01-24 06:07:02] serge@globalbeach.com Hi again, I take that back, its happening in 4.0.6 as well. [Thu Jan 24 11:03:32 2002] [error] db02, [system] [/websites/dev.one2infinity.net/login.php:37] SQL error: ô¿z, SQL state (ûä' ± in SQLExecDirect,0 Thanks, Serge ------------------------------------------------------------------------ [2002-01-24 06:00:51] serge@globalbeach.com Hi All, I am running PHP 4.1.1 with the ODBC module and Easysoft's (www.easysoft.co.uk) ODBC-ODBC bridge client. I seem to be gettting random SQLExecDirect errors when running queries. The State part of the error message just has garbage in it, there apears to be some sort of coruption? When I roll back to PHP 4.0.6 using the same build parameters I used for 4.1.1 I do not get this error anymore. my configure statement looks like this: # ./configure --with-apache=../apache_1.3.22 --enable-exif --enable-track-vars --with-gdbm --enable-ftp --with-gd --with-esoob=/usr/local/easysoft/oob/client --with-mm=/usr/local --enable-trans-sid --with-jpeg-dir=/usr/lib --with-gif-dir=/usr/lib --with-curl=/usr/local Sorry I do not have more info then this on the problem. Its random (but frequent) nature make its hard to track. Thanks, Serge P.S. The code I am using is stable and has been running fine on 4.0.6 for half a year. ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=15199&edit=1