#19213 [Bgs]: odbc_close() not working?

ID: 19213 Updated by: kalowsky@php.net Reported By: a.steckenborn@stebosoft.de Status: Bogus Bug Type: ODBC related Operating System: SuSE Linux 8.0 PHP Version: 4.3.0-dev New Comment: Not completely bogus as the close bug was fixed for 4.2.3, but this was looking like a driver specific bug of it. Thankfully it was truely driver specific. Jani at the Kongress you better have a few drinks from this guy for me! Previous Comments: ------------------------------------------------------------------------ [2002-10-27 17:34:00] sniper@php.net So I guess this is bogus bug report then..? :) ------------------------------------------------------------------------ [2002-10-27 15:18:38] a.steckenborn@stebosoft.de today i've tested the whole day. after logging the sql statements i found out, that sometimes 2 requests are coming up, the first without the needed parameters and the second with. And that is related by a bug in our select script. Now I'm really shamed. :-( Next time you are near by Ludwigshafen, Germany send me a mail you will get some free drinks by me. A lot of thanks for your great work. with best regards Albert Steckenborn ------------------------------------------------------------------------ [2002-10-27 10:18:19] sniper@php.net updated version and summary. ------------------------------------------------------------------------ [2002-10-27 04:08:25] a.steckenborn@stebosoft.de Nothing has changed with the latest snapshot php4-200210270000 with a second ODBC-connect to the SAPDB database within 10 sec. the PHP-error occours like before --------snip----- [27-Oct-2002 11:06:55] PHP Warning: SQL error: [SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access violation;-3014 POS(272) Invalid end of SQL statement., SQL state 37000 in SQLPrepare in /www/kunden/reisenetz/web/show.phtml on line 151 [27-Oct-2002 11:06:55] PHP Warning: odbc_execute(): supplied argument is not a valid ODBC result resource in /www/kunden/reisenetz/web/show.phtml on line 152 [27-Oct-2002 11:07:05] PHP Warning: SQL error: [SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access violation;-3014 POS(272) Invalid end of SQL statement., SQL state 37000 in SQLPrepare in /www/kunden/reisenetz/web/show.phtml on line 151 [27-Oct-2002 11:07:05] PHP Warning: odbc_execute(): supplied argument is not a valid ODBC result resource in /www/kunden/reisenetz/web/show.phtml on line 152 --------snip------------- but the ODBC_Result is ok. The Memory-Usage looks very better with SAPDB, PHP4.2.3 and Apache1.3.27 It seems as if my Memory-Leak is fixed. Thanks a lot to all that are working at these problems with best regards Albert Steckenborn ------------------------------------------------------------------------ [2002-10-26 16:25:29] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19213 -- Edit this bug report at http://bugs.php.net/?id=19213&edit=1