Azure-Samples/azure-sql-db-python-rest-api

ODBC connection pooling in Linux

Lisa999 opened this issue · 2 comments

Lisa999 commented

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?

ErikvdVen commented

Wondering the same thing over here.

yorek commented

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.