Release Notes for Microsoft ODBC Driver for SQL Server on Windows
This release notes article describes what's new for the Microsoft ODBC driver for SQL Server on Windows.
18.4
Version number: 18.4.1.1
Released: July 31, 2024
Download x64 installer
Download x86 installer
Download ARM64 installer
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the ARM64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| New item | Details |
|---|---|
| Microsoft Entra ID | Renamed all occurrences of "Azure Active Directory" to "Microsoft Entra ID". See New name for Azure Active Directory for more information. |
| Bug fixes. | Bug fixes. |
18.3.3
Version number: 18.3.3.1
Released: April 9, 2024
Download x64 installer
Download x86 installer
Download ARM64 installer
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the ARM64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
| Security updates | KB5037571 |
17.10.6
Download x64 installer
Download x86 installer
Version number: 17.10.6.1
Released: April 9, 2024
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
| Security updates | KB5037570 |
Previous Releases
18.3.2
Version number: 18.3.2.1
Released: October 10, 2023
Download x64 installer
Download x86 installer
Download ARM64 installer
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the ARM64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
17.10.5
Download x64 installer
Download x86 installer
Version number: 17.10.5.1
Released: October 10, 2023
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Improved Performance | More efficient packet buffer memory allocation |
| New Managed Identity (MSI) Authentication Support | Support for MSI authentication for Azure Arc and Azure Cloud Shell and updated to a newer Azure App Service API version |
| Bug fixes | Bug fixes. |
18.3.1
Version number: 18.3.1.1
Released: July 31, 2023
Download x64 installer
Download x86 installer
Download ARM64 installer
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the ARM64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Improved Performance | More efficient packet buffer memory allocation |
| New Managed Identity (MSI) Authentication Support | Support for MSI authentication for Azure Arc and Azure Cloud Shell and updated to a newer Azure App Service API version |
| Bug fixes | Bug fixes. |
18.2.2
Version number: 18.2.2.1
Released: June 15, 2023
Download x64 installer
Download x86 installer
Download ARM64(Preview) installer
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the ARM64(Preview) driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
17.10.4.1
Download x64 installer
Download x86 installer
Version number: 17.10.4.1
Released: June 15, 2023
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
18.2
Download x64 installer
Download x86 installer
Download ARM64(Preview) installer
Version number: 18.2.1.1
Released: January 31, 2023
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the ARM64(Preview) driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| New distribution supported | Windows ARM64(Preview) |
| Bug fixes | Bug fixes. |
17.10.3
Download x64 installer
Download x86 installer
Version number: 17.10.3.1
Released: January 26, 2023
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
18.1.2
Download x64 installer
Download x86 installer
Version number: 18.1.2.1
Released: November 3, 2022
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
17.10.2
Download x64 installer
Download x86 installer
Version number: 17.10.2.1
Released: November 28, 2022
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Fix custom action DLL signing | Fix custom action DLL signing |
| Bug fixes | Bug fixes. |
18.1
Download x64 installer
Download x86 installer
Version number: 18.1.1.1
Released: August 8, 2022
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| IpAddressPreference option | See DSN and Connection String Attributes and Keywords. |
| RetryExec option | See DSN and Connection String Attributes and Keywords. |
| VBS-NONE enclave attestation protocol | New enclave attestation option to not attest the enclave. See Using Always Encrypted |
| Wildcard matching of HostnameInCertificate | Now able to use wildcard for specifying hostname, if different from default value found in Addr/Address/Server. |
| ServerCertificate option | See DSN and Connection String Attributes and Keywords. |
| TrustedConnection_UseAAD option | Now only Kerberos integrated authentication is enabled when specifying Trusted_Connection=yes. Use the TrustedConnection_UseAAD option to enable the previous behavior of using either Kerberos or Azure Active Directory integrated. For more information, see Using Azure Active Directory. |
| Bug fixes | Bug fixes. |
17.10
Download x64 installer
Download x86 installer
Version number: 17.10.1.1
Released: June 30, 2022
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| TrustedConnection_UseAAD option | Now only Kerberos integrated authentication is enabled when specifying Trusted_Connection=yes. Use the TrustedConnection_UseAAD option to enable the previous behavior of using either Kerberos or Azure Active Directory integrated. |
| Bug fixes | Bug fixes. |
18.0
Download x64 installer
Download x86 installer
Version number: 18.0.1.1
Released: February 15, 2022
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Added compatibility with OpenSSL 3.0 | See Connection String Keywords and Data Source Names. |
| Ability to send long types as max types | See DSN and Connection String Attributes and Keywords. |
| Secure by default | BREAKING CHANGE Default Encrypt to Yes/Mandatory. Changed certificate validation behavior to validate when encryption is negotiated from either the client or the server side, not just the client side. For more information, see the ODBC Driver 18.0 release announcement. |
| Support for TDS 8.0 | See Features of the Microsoft ODBC Driver for SQL Server on Windows. |
| Compatibility extensions for SQLGetData | See Features of the Microsoft ODBC Driver for SQL Server on Windows. |
| Bug fixes | Bug fixes. |
17.9
Download x64 installer
Download x86 installer
Version number: 17.9.1.1
Released: February 17, 2022
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Added compatibility with OpenSSL 3.0 | See Connection String Keywords and Data Source Names. |
17.8
Download x64 installer
Download x86 installer
Version number: 17.8.1.1
Released: July 30, 2021
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Ability to modify KeyStoreAuthentication and KeyStorePrincipalId in DSN configuration UI | See Using Always Encrypted. |
| Replication option added to the connection string | See DSN and Connection String Attributes and Keywords. |
| KeepAlive and KeepAliveInterval options added to the connection string | See DSN and Connection String Attributes and Keywords. |
| Bug fixes | Bug fixes. |
17.7.2
Download x64 installer
Download x86 installer
Version number: 17.7.2.1
Released: March 10, 2021
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Bug fixes | Bug fixes. |
17.7
Download x64 installer
Download x86 installer
Version number: 17.7.1.1
Released: January 29, 2021
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Azure Key Vault Interactive Authentication | See Using Always Encrypted. |
| Service Principal Authentication | See DSN and Connection String Attributes and Keywords. |
| Ability to insert into encrypted money and smallmoney columns | See Using Always Encrypted. |
| Bug fixes | Bug fixes. |
17.6
Download x64 installer
Download x86 installer
Version number: 17.6.1.1
Released: July 31, 2020
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
| Feature added | Details |
|---|---|
| Metadata caching for prepared statements | See Using Always Encrypted. |
| SQL_COPT_SS_AUTOBEGINTXN connection attribute to control whether automatic BEGIN TRANSACTION happens after ROLLBACK or COMMIT | See DSN and Connection String Attributes and Keywords. |
| Bug fixes | Bug fixes. |
17.5.2
Download x64 installer
Download x86 installer
Version number: 17.5.2.1
Released: March 6, 2020
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.5.2
| Feature added | Details |
|---|---|
| Support authentication with Managed Identity for Azure Key Vault | See Using Always Encrypted with the ODBC Driver. |
| Support for more Azure Key Vault endpoints | See Using Always Encrypted with the ODBC Driver. |
| Bug fixes | See Bug fixes. |
Download previous ODBC Driver versions by clicking the download links in the following sections:
17.5
Download x64 installer
Download x86 installer
Version number: 17.5.1.1
Released: January 31, 2020
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.5
| Feature added | Details |
|---|---|
| SQL_COPT_SS_SPID connection attribute to retrieve SPID without round trip to server | See DSN and Connection String Attributes and Keywords. |
| Bug fixes | See Bug fixes. |
17.4.2
Download x64 installer
Download x86 installer
Version number: 17.4.2.1
Released: October 2019
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.4.2
| Feature added | Details |
|---|---|
| Support for more Azure Key Vault endpoints | See Using Always Encrypted with the ODBC Driver. |
| Support for setting data classification version | See Data Classification. |
| Include Azure Active Directory Authentication Library (adal.dll) in the installer | Now included in the base driver installation, the ODBC installer upgrades existing installations of the Microsoft Active Directory Authentication Library for SQL Server, removing it from the list of installed applications in Windows. |
| Bug fixes | See Bug fixes. |
17.4
Download x64 installer
Download x86 installer
Version number: 17.4.1.1
Released: July 2019
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.4
| Feature added | Details |
|---|---|
| Always Encrypted with secure enclaves. | See Using Always Encrypted with the ODBC Driver. |
| Configurable TCP Keep Alive settings. | See Connecting to SQL Server. |
| Bug fixes | See Bug fixes. |
17.3
Download x64 installer
Download x86 installer
Version number: 17.3.1.1
Released: February 2019
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.3
| Feature added | Details |
|---|---|
| Azure Active Directory Managed Identity (system and user-assigned) authentication mode. | See Using Azure Active Directory with the ODBC Driver. |
| Ability to stream input parameters against Always Encrypted columns. | See Limitations of the ODBC driver when using Always Encrypted. |
| XA distributed transactions. | Using XA Transactions. |
| Updated Visual C++ Redistributable | Upgraded the runtime dependency to the Visual C++ 2017 Redistributable (x64 Download, x86 Download) |
| Bug fixes | See Bug fixes. |
17.2
Download x64 installer
Download x86 installer
Version number: 17.2.0.1
Released: July 2018
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.2
| Feature added | Details |
|---|---|
| Data Classification for Azure SQL Database and SQL Server. | See Data Classification. |
| Support for UTF-8 server encoding. | |
| Bug fixes | See Bug fixes. |
17.1
Download x64 installer
Download x86 installer
Version number: 17.1.0.1
Released: March 2018
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.1
| Feature added | Details |
|---|---|
Support for SQL_COPT_SS_CEKCACHETTL and SQL_COPT_SS_TRUSTEDCMKPATHS connection attributes. |
• SQL_COPT_SS_CEKCACHETTLAllows controlling the time that the local cache of Column Encryption Keys exists, and flushing it. • SQL_COPT_SS_TRUSTEDCMKPATHSAllows 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 | |
| Bug fixes | See Bug fixes. |
17.0
Download x64 installer
Download x86 installer
Version number: 17.0.1.1
Released: February 2018
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added in 17.0
| Feature added | Details |
|---|---|
| Always Encrypted support for BCP API. | |
New connection string attribute UseFMTOnly. |
Causes the driver to use legacy metadata in special cases that require temporary tables. |
| Support for Azure SQL Managed Instance. | See the following list of Differences when using Managed Instance (ODBC version 17). |
| Dependency changed | Details |
|---|---|
| Removed Microsoft online service sign-in assistant | The dependency is removed. |
Differences when using Managed Instance (ODBC version 17)
This version of ODBC contains support for Azure SQL Managed Instance. See the following noted list of differences when using Managed Instance.
Note
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 trace files.
- Create UDT from local path is not supported.
- Windows Integrated Authentication is not supported.
- DTC is not supported.
saaccount is not present (default account is calledcloudSA).- 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).
13.1
Download x64 installer
Download x86 installer
Version number: 13.1
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Download the Microsoft Command Line Utilities 13.1 for SQL Server
Features added in 13.1
| Feature added | Details |
|---|---|
| ODBC Driver 13.1 for SQL Server adds support for Always Encrypted and Azure Active Directory. | These added supports are available when connecting to Microsoft SQL Server 2016, or to a later version. |
| There are connection pooling keywords and attributes that correspond to the supports for Always Encrypted and Azure Active Directory. | These keywords and attributes are described in Driver Aware Connection Pooling in the ODBC Driver for SQL Server. |
13
Download x64 installer
Download x86 installer
Version number: 13
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Download the Microsoft Command Line Utilities 13 for SQL Server
Features added in 13
| Feature added | Details |
|---|---|
| Adds support for Microsoft SQL Server 2016. | Retains the functionality of ODBC driver version 11. |
11
Download x64 installer
Download x86 installer
Version number: 11
If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Download the Microsoft Command Line Utilities 11 for SQL Server
Features added in 11
| Feature added | Details |
|---|---|
| Contains new features. | See Features of the Microsoft ODBC Driver for SQL Server on Windows. |
| Contains all the features that shipped with ODBC in SQL Server 2012 Native Client. | |