Bug #12702: odbc_connect() and odbc_pconnect() fail

From: ctr2sprt@yahoo.com Operating system: Debian GNU/Linux PHP version: 4.0.6 PHP Bug Type: ODBC related Bug description: odbc_connect() and odbc_pconnect() fail Using unixODBC 2.0.8-2 and php4 3:4.0.6-4 (recompiled to add unixODBC support). unixODBC connects to a DB2 V7.1 database using DB2's provided ODBC driver. Connection attempts fail with: Warning: SQL error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed, SQL state IM004 in SQLConnect isql will connect and work correctly (even as the user wwwdata), and from my examinations of the source of PHP and isql the connection process is identical unless one of the PHP functions (like the malloc() equivalent) is failing. If I restart Apache (and hence PHP), it works fine. This smacks of a persistent-connections bug. It first appeared when I was trying to fix ADODB to work with ODBC: ADODB wants to use persistent connections, but it seems as if either PHP or DB2 can't handle them. I never knew that bringing DB2 support to Snort and ACID would be so much work! -- Edit bug report at: http://bugs.php.net/?id=12702&edit=1