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 ofpymssql.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
andDATETIME2
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
andIMAGE
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.