Bug #22986 [Ana]: Unhappily 'conection cache' handling

Edit report at https://bugs.php.net/bug.php?id=22986&edit=1 ID: 22986 Updated by: cmb@php.net Reported by: ray at unreal64 dot net Summary: Unhappily 'conection cache' handling Status: Analyzed Type: Bug Package: ODBC related Operating System: Windows NT4.0 PHP Version: 4.x Block user comment: N Private report: N New Comment: > […], if the system supports ODBC connection pooling; a > respective note for PDO ODBC[1] also applies to ext/odbc. No, ext/odbc does not support ODBC connection pooling at all. Previous Comments: ------------------------------------------------------------------------ [2020-09-27 19:16:05] cmb@php.net Related To: Bug #33797 ------------------------------------------------------------------------ [2020-06-24 11:11:50] cmb@php.net I agree that trying to re-use a persistent connection even though odbc_connect() is called is more like a bug. However, changing that in a stable PHP version may cause a BC break (some setups may rely on the behavior). Furthermore, persistent ODBC connections may not be the best idea at all, if the system supports ODBC connection pooling; a respective note for PDO ODBC[1] also applies to ext/odbc. [1] <https://www.php.net/manual/en/pdo.connections.php> ------------------------------------------------------------------------ [2017-10-24 02:21:12] kalle@php.net I would argue that this is more a bug, gonna re-classify it as such as by looking at the code of ext/odbc it still seems to be present today ------------------------------------------------------------------------ [2003-05-18 22:31:01] kalowsky@php.net Updating the verison since this effects ALL PHP4 installations. Hopefully this won't be the case with 5 if I can get things done :) ------------------------------------------------------------------------ [2003-05-18 22:30:15] kalowsky@php.net Yes yes, this is on my TODO list. In fact it's kind of working already, I just haven't commited any code. Moving this from a bug to a feature request, because it's not really a bug. You are correct though that you can change the password/user to get around this, but an even easier solution is to change the cursor type. ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=22986 -- Edit this bug report at https://bugs.php.net/bug.php?id=22986&edit=1