PHP 4.0 Bug #6083 Updated: odbc_pconnect($dbu, $dbp, []) will not generate a new ID on the same dbuser!

ID: 6083 Updated by: kara Reported By: oo@tedas.de Status: Closed Bug Type: ODBC related Assigned To: Comments: You are addressing two different issues: 1. You cannot open two sessions for the same user/database in a single script. 2. You cannot resume a session and it's pending transactions between two HTTP requests. Ad 1: The idea behind persistent connection is to reuse connections - if you really need two separate transactions for one user in a single script, you could get this by setting ODBC Options different in odbc_connect() to get two connections. Or you could create two users. Ad 2: AFAIK, it is impossible with ODBC to resume a particular session between two scripts while keeping the connection open, and it has to remain open to not end the transaction. (with Oracle 8i it could theoretically be possible because of a distinction between connection to a server and a user session) This would be possible in a threaded Webserver - but as it is today, each thread (or with Apache each process) has its own set of persistent connections - and it is impossible to direct a HTTP request to a specific thread/process. Full Bug description available at: http://bugs.php.net/?id=6083