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 |
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
.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 |
msodbcsql.msi
from one of the Downloads for Windows.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.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.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.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.msodbcsql11.lib
and msodbcsql.h
, use 'DRIVER={ODBC Driver 11 for SQL Server}' in the connection string.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. |