php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #15199 Random SQLExecDirect error
Submitted: 2002-01-24 06:00 UTC Modified: 2002-01-25 03:58 UTC
From: serge at globalbeach dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.1.1 OS: RH 7.2 / 2.4.17
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: serge at globalbeach dot com
New email:
PHP Version: OS:

 

 [2002-01-24 06:00 UTC] serge at globalbeach dot 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-01-24 06:07 UTC] serge at globalbeach dot 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-25 03:58 UTC] serge at globalbeach dot com 
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
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 15:01:30 2025 UTC