--
You received this message because you are subscribed to the Google Groups "pymssql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pymssql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pymssql/733d4840-fe65-46ae-8b99-b42fbb5c32dfn%40googlegroups.com.
pyodbc requires a ODBC driver. One nice thing about pymssql is that no driver is needed.
You could also look at pytds https://python-tds.readthedocs.io/en/latest/pytds.html#pytds.connect …I have not yet used that, but intend to try it out.
pymssql works, and Mikhail Terekhov (termim) has done a lot of work on it in 2021 and 2022.
Unfortunately for my multi-threaded use case, versions after 2.1.5 do not work when the SQL connection is accessed from a thread other than the one that created it. https://github.com/pymssql/pymssql/issues/735
To view this discussion on the web visit https://groups.google.com/d/msgid/pymssql/CAGVM7W%3DCMW1EXbrZaPMac0Yq1DNUvJ4hvQGxJRgtkPT_BjJt1Q%40mail.gmail.com.