Open
Description
Unfortunately as of today (March 2020) ODBC connection pooling in Linux does work as expected to due an issue in unixODBC library.
Is this still true? Link to the issue?
Metadata
Metadata
Assignees
Labels
No labels
{{ message }}
No one assigned
No labels
No type
No projects
No milestone
None yet
No branches or pull requests
Activity
ErikvdVen commentedon Aug 25, 2022
Wondering the same thing over here.
yorek commentedon Aug 25, 2022
Hi, it seems that the issue has been fixed, as per http://www.unixodbc.org/ news on 02 May 2022.
I haven't had the chance yet to test everything out, so if you want to try and check that now everything is working as expected, even without my workaround, that would be great!
To be clear, the issue was that sp_reset_connection was not called by the ODBC driver and thus the connection couldn't be reused for real, and the reason was that "SQL_ATTR_RESET_CONNECTION is a new connection attribute introduced for ODBC 3.8 driver. It can only be called by DM to reset a connection."
It has now been added: lurcher/unixODBC@c08a352 so it should work just fine.