pymssql v2.1.4 Release Notes

Release Date: 2018-08-28 // over 5 years ago
  • General

    • ๐Ÿ‘ Allow linkage against FreeTDS (by dropping usage of deprecated DBVERSION_80 symbol.) (GH-432)

    • 0๏ธโƒฃ Stop using 7.1 as default value for the TDS protocol version used in connections.

    This is a backward incompatible change and affects connections using both pymssql and _mssql.

    Now you need to specify a TDS protocol version explicitly by using any of the supported mechanisms (in descending order of precedence):

    • Using the tds_version paramenter of pymssql.connect() and _mssql.connect()
    • A TDSVER enviromnent variable (see FreeTDS documentation)
    • A freetds.conf file (see FreeTDS documentation)

      • โฌ‡๏ธ Drop support for versions of FreeTDS older than 0.91.
      • Accept 7.3 as TDS protocol version when establishing a connection.
      • โž• Add Python 3.7 support
      • โฌ‡๏ธ Drop Python 3.3 support

    ๐Ÿ”‹ Features

    • ๐Ÿ‘Œ Support for new in SQL Server 2008 DATE, TIME and DATETIME2 data types (GH-156). The following conditions need to be additionally met so values of these column types can be returned from the database as their native corresponding Python data types instead of as strings:

      • Underlying FreeTDS must be 0.95 or newer.
      • TDS protocol version in use must be 7.3 or newer.

    Thanks Ed Avis for the implementation. (GH-331)

    ๐Ÿ› Bug fixes

    • ๐Ÿ‘ Finish implementation of TDS protocol version 7.3 support by actually accepting "7.3" as TDS protocol version when establishing a connection. (GH-455)
    • ๐Ÿ›  Fixed and expanded Python data types that can be used to pass VARBINARY, BINARY and IMAGE SQL Server Stored Procedures input parameters. (GH-425). Thanks Bill Adams for the fix.
    • ๐Ÿ”– Fix tds_version _mssql connection property value for TDS version. 7.1 is actually 7.1 and not 8.0.