From: [EMAIL PROTECTED]
Operating system: Windows 2000 UK Advanced Server
PHP version: 4.1.2
PHP Bug Type: Reproducible crash
Bug description: Crash after 50-164 odbc queries on db2 dbase server
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 bug report at http://bugs.php.net/?id=16221&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=16221&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=16221&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16221&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16221&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16221&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16221&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16221&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16221&r=submittedtwice
