This article discusses the ODBC drivers that connect to SQL Server.
SQL version compatibility
Compatibility indicates that a driver was tested for compatibility against existing releases of SQL at the time of the driver's release. SQL Server releases generally try to maintain backwards compatibility with existing client drivers. But new features in SQL Server releases may not be available with older client drivers.
Microsoft Windows - The ODBC database drivers are usually pre-installed with the Windows operating systems. Linux and Apple MacOS - This is the link to the Microsoft Docs site that outlines how to install the driver based on your specific Operating System: Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS. We suggest that you use the MD5 checksums and GnuPG signatures to verify the integrity of the packages you download. Connector/ODBC is a standardized database driver for Windows, Linux, Mac OS X, and Unix platforms.
| Database version → ↓ Driver Version | Azure SQL Database | Azure Synapse Analytics | Azure SQL Managed Instance | SQL Server 2019 | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 | SQL Server 2008 | SQL Server 2005 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17.6 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
| 17.5 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
| 17.4 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
| 17.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 17.2 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 17.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 17.0 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 13.1 | Yes | Yes | Yes | Yes | Yes | Yes | |||||
| 13 | Yes | Yes | Yes | Yes | Yes | ||||||
| 11 | Yes | Yes | Yes | Yes | Yes |
Connection string details
The driver name that you specify in a connection string is ODBC Driver 11 for SQL Server or ODBC Driver 13 for SQL Server (for both 13 and 13.1) or ODBC Driver 17 for SQL Server.
Supported operating systems
The following matrix indicates driver version support for Windows operating system versions:
| Operating system → ↓ Driver version | Windows Server 2019 | Windows Server 2016 | Windows Server 2012 R2 | Windows Server 2012 | Windows Server 2008 R2 | Windows 10 | Windows 8.1 | Windows 7 | Windows Vista SP2 |
|---|---|---|---|---|---|---|---|---|---|
| 17.6 | Yes | Yes | Yes | Yes | Yes | Yes | |||
| 17.5 | Yes | Yes | Yes | Yes | Yes | Yes | |||
| 17.4 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 17.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 17.2 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 17.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 17.0 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 13.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 13 | Yes | Yes | Yes | Yes | |||||
| 11 | Yes | Yes | Yes | Yes |
Installing Microsoft ODBC Driver for SQL Server
The driver is installed when you run msodbcsql.msi from one of the Downloads for Windows.
Note
For those who have Driver 17.1.0.1 or below installed, it is recommended that it be uninstalled manually prior to installing the newer version of the Driver.
Side-by-side with Native Client
The driver can be installed side-by-side with SQL Server Native Client. Major versions of the driver (11, 13, 17) can all be installed side-by-side with each other, as well.
When you invoke msodbcsql.msi, only the client components are installed by default. The client components are files that support running an application that was developed using the driver. To install the SDK components, specify ADDLOCAL=ALL on the command line. Here is an example.
End-user license
Specify IACCEPTMSODBCSQLLICENSETERMS=YES to accept the terms of the end-user license if you use the /passive, /qn, /qb, or /qr option to install. This option must be specified in all uppercase letters. Here is an example.
Silent uninstall
The following example shows how to perform a silent uninstall.
Indicate dependency
When an application uses the driver, the application should indicate that it depends on the driver through the install option APPGUID. this indication enables the driver installer to report dependent applications before uninstalling. To specify a dependency on the driver, set the APPGUID command-line parameter to your product code when silently installing the driver. A product code must be created when using Microsoft Installer to bundle your application setup program. Here is an example.
Command-line tools: sqlcmd.exe and bcp.exe
The bcp.exe and sqlcmd.exe tools for use with the driver can be downloaded at Microsoft Command Line Utilities 11 for SQL Server, Microsoft Command Line Utilities 13 for SQL Server, or Microsoft Command Line Utilities 13.1 for SQL Server. The driver is a prerequisite to install sqlcmd.exe and bcp.exe.
bcp.exe and sqlcmd.exe are installed in the 110Tools subfolder of %PROGRAMFILES%Microsoft SQL ServerClient SDKODBC for version 11, and 130Tools for 13 and 13.1.
An application that uses BCP functions must specify the driver from the same version which shipped with the header file and library used to compile the application.
For example, when you compile an ODBC application with msodbcsql11.lib and msodbcsql.h, use 'DRIVER={ODBC Driver 11 for SQL Server}' in the connection string.
Components of the Microsoft ODBC Driver for SQL Server on Windows
The ODBC driver on Windows contains the following components:
| Component | Description |
|---|---|
| msodbcsql17.dll or msodbcsql13.dll or msodbcsql11.dll | The dynamic-link library (DLL) file that contains all of the driver's functionality. This file is installed in %SYSTEMROOT%System32. |
| msodbcdiag17.dll or msodbcdiag13.dll or msodbcdiag11.dll | The dynamic-link library (DLL) file that contains the driver's diagnostics (tracing) interface. This file is installed in %SYSTEMROOT%System32. |
| msodbcsqlr17.rll or msodbcsqlr13.rll or msodbcsqlr11.rll | The accompanying resource file for the driver library. This file is installed in %SYSTEMROOT%System321033. |
| s13ch_msodbcsql.chm or s11ch_msodbcsql.chm | The Data Source Wizard help file that documents how to create a data source for the driver. This file is installed in %SYSTEMROOT%System321033 NOTE: There is no chm file for ODBC Driver 17. |
| msodbcsql.h | The header file that contains all of the new definitions needed to use the driver. Note: You cannot reference msodbcsql.h and odbcss.h in the same program. msodbcsql.h for ODBC Driver 17 or 13 is installed in %PROGRAMFILES%Microsoft SQL ServerClient SDKODBC130SDK. msodbcsql.h for ODBC Driver 11 is installed in %PROGRAMFILES%Microsoft SQL ServerClient SDKODBC110SDK. |
| msodbcsql17.lib or msodbcsql13.lib or msodbcsql11.lib | The library file needed to call the bcp utility functions that are part of the driver. Note: If you do reference this library file in your program, make sure that it is in your system path and in the system path of those that use the application. msodbcsql17.lib or msodbcsql13.lib is installed in %PROGRAMFILES%Microsoft SQL ServerClient SDKODBC130SDK. msodbcsql11.lib is installed in %PROGRAMFILES%Microsoft SQL ServerClient SDKODBC110SDK. |
See also
-->This release notes article describes what's new for the Microsoft ODBC driver for SQL Server on Windows.
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. |
Previous Releases
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 additional 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 additional 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 will upgrade 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, as well as 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
Paxera viewer for mac download. 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 has been 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.
Microsoft Odbc Driver 13 For Sql Server Download
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
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
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
Microsoft Odbc Driver 11 For Sql Server
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 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. |