Bug #12552 connection pooling does not work with MyODBC
Submitted: 12 Aug 2005 14:31 Modified: 12 Aug 2005 17:02
Reporter: Mathieu DESPRIEE Email Updates:
Status: Verified Impact on me:
Category:Connector / ODBC Severity:S4 (Feature request)
Version:3.51 OS:Windows (windows)
Assigned to: CPU Architecture:Any

[12 Aug 2005 14:31] Mathieu DESPRIEE
It seems that the MyODBC driver is not conform to the version 3.0 of ODBC Manager API, which is designed to handle connection pooling.
Result is that connection pooling does not work with MyODBC.

see http://www.sonic.net/~mroeder/myodbc-connection-pooling.html


How to repeat:
see http://www.sonic.net/~mroeder/myodbc-connection-pooling.html

Suggested fix:
The Microsoft documentation says that the ODBC application needs to call SQLSetEnvAttr with SQL_ATTR_CONNECTION_POOLING.