- changed status to resolved
don't rely on odbc SQL_DBMS_VER for SQL server
Issue #3814
resolved
I'm on freetds 0.95 and again getting a garbage '95.12.255' value for SQL Server version, no matter what I set TDS_VERSION towards. Suggest constructing a lookup table based on the values in https://msdn.microsoft.com/en-us/library/ms174396.aspx.
Comments (2)
-
reporter -
reporter Use SQL Server SERVERPROPERTY for version info w/ pyodbc
Updated the server version info scheme for pyodbc to use SQL Server SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which continues to be unreliable particularly with FreeTDS.
Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce Fixes:
#3814(cherry picked from commit f0ea9e37f94bd39fa4f0785dbdcd0ee1759c4a11)→ <<cset 17f3f4b1e11f>>
- Log in to comment
Use SQL Server SERVERPROPERTY for version info w/ pyodbc
Updated the server version info scheme for pyodbc to use SQL Server SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which continues to be unreliable particularly with FreeTDS.
Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce Fixes:
#3814→ <<cset f0ea9e37f94b>>