#16221 [Com]: Crash after 50-164 odbc queries on db2 dbase server
| From: | fj at hf dot hutg | Date: | Fri, 14 Sep 2007 07:02:37 +0000 |
| Subject: | #16221 [Com]: Crash after 50-164 odbc queries on db2 dbase server | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-117547@lists.php.net to get a copy of this message | ||
ID: 16221
Comment by: fj at hf dot hutg
Reported By: j dot marijne at webxpose dot nl
Status: No Feedback
Bug Type: ODBC related
Operating System: Windows 2000 UK Advanced Server
PHP Version: 4.1.2
New Comment:
http://www.meta-fx.com/
Previous Comments:
------------------------------------------------------------------------
[2002-07-26 01:00:10] 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".
------------------------------------------------------------------------
[2002-06-17 20:44:14] sniper@php.net
Does this happen with this snapshot:
http://snaps.php.net/win32/php4-win32-latest.zip
------------------------------------------------------------------------
[2002-03-22 10:31:50] 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'");
$counter=0;
while ($counter <5000)
{
$query="select * from tms_user";
$result=odbc_exec($connection,$query);
$temp=odbc_fetch_row ($result);
echo "counter= $counter <br>";
odbc_free_result($result);
odbc_close_all();
$counter++;
}
?>
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
WebXpose
The Netherlands
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=16221&edit=1