1. Mike Bayer Avatar Mike Bayer
  2. Untitled project
  3. sqlalchemy_old
  4. Issues

don't rely on odbc SQL_DBMS_VER for SQL server

Issue #3814 resolved
Mike Bayer repo owner created an issue

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)

  1. Mike Bayer 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

    → <<cset f0ea9e37f94b>>

  2. Mike Bayer 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>>

  3. Log in to comment
Assignee
–
Type
bug
Priority
major
Status
resolved
Component
mssql
Milestone
1.0.xx
Votes
0
Watchers
1
Jira: the preferred issue tracker for Bitbucket. Join the team!