Release Notes for ODBC to SQL Server on Windows
3 minutes to read
In this article
Download ODBC Driver
This release notes article describes what's new for the Microsoft ODBC driver for SQL Server on Windows.
17.5, January 2020
17.4.2, October 2019
Support for additional Azure Key Vault endpoints
Using Always Encrypted with the ODBC Driver.
Support for setting data classification version
Include Azure Active Directory Authentication Library (adal.dll) in the installer
Now included in the base driver installation, this will upgrade existing installations of the Microsoft Active Directory Authentication Library for SQL Server, removing it from the list of installed applications in Windows.
17.4, July 2019
17.3, February 2019
17.2, July 2018
Data Classification for Azure SQL Database and SQL Server.
Support for UTF-8 server encoding.
17.1, March 2018
SQL_COPT_SS_TRUSTEDCMKPATHS connection attributes.
Allows controlling the time that the local cache of Column Encryption Keys exists, as well as flushing it. •
Allows the application to restrict AE operations to only use the specified list of Column Master Keys. For more information, see Using Always Encrypted with the ODBC Driver for SQL Server.
Azure Active Directory Interactive Authentication Support
17, February 2018
Always Encrypted support for BCP API.
New connection string attribute
Causes the driver to use legacy metadata in special cases that require temporary tables.
Support for Azure SQL Managed Instance.
Extended Private Preview.
See the following list of Differences when using Managed Instance (ODBC version 17).
Removed Microsoft online service sign-in assistant
The dependency has been removed.
Differences when using Managed Instance (ODBC version 17)
This version of ODBC contains support for Azure SQL Managed Instance (Extended Private Preview). See the following noted list of differences when using Managed Instance.
There are a number of differences when using Managed Instance:
FILESTREAM is not supported.
Local filesystem access is not supported, but is required for things like tracefiles.
Create UDT from local path is not supported.
Windows Integrated Authentication is not supported.
DTC is not supported.
sa account is not present (default account is called
TDS token ERROR (0xAA) returns incorrect server name.
Special characters in database name are not supported.
ALTER DATABASE [dbname1] MODIFY NAME = [dbname2] is not supported.
The error messages are always shown in English, regardless of language settings (same as Azure).
Adds support for Microsoft SQL Server 2016.
Retains the functionality of ODBC driver version 11.