|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #16221 Crash after 50-164 odbc queries on db2 dbase server
Submitted: 2002-03-22 10:31 UTC Modified: 2002-07-26 01:00 UTC
Avg. Score:4.4 ± 0.9
Reproduced:5 of 5 (100.0%)
Same Version:2 (40.0%)
Same OS:4 (80.0%)
From: j dot marijne at webxpose dot nl Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 4.1.2 OS: Windows 2000 UK Advanced Server
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: j dot marijne at webxpose dot nl
New email:
PHP Version: OS:


 [2002-03-22 10:31 UTC] j dot marijne at webxpose dot nl
After doing between 50-182 query's to IBM DB2 7 on Windows 2000 (localhost) with this script:

$connection = odbc_connect( "test","db2admin", "admin" ) 
or die("Unable to connect to SQL server");
$result=odbc_exec($connection,"set current sqlid = 'DB2ADMIN'");		
while ($counter <5000)
$query="select * from tms_user";
$temp=odbc_fetch_row ($result);
echo "counter= $counter <br>";


I get the following error:
Warning: SQL error: [IBM][CLI Driver][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011 , SQL state 57011 in SQLExecDirect in f:\inetpub\wwwroot\mr-sales-mysql\test.php on line 13

Warning: Supplied argument is not a valid ODBC result resource in f:\inetpub\wwwroot\mr-sales-mysql\test.php on line 14
counter= 164

If I use an odbc connection to a mysql database server, everything works fine.

Kind regards,

Joop Marijne
The Netherlands


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2002-06-17 20:44 UTC]
Does this happen with this snapshot:

 [2002-07-26 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2007-09-14 07:02 UTC] fj at hf dot hutg
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Jul 23 06:01:30 2024 UTC