-->

This article discusses the ODBC drivers that connect to SQL Server.

TLS 1.2 Support for SQL. TLS 1.2 are SQL Server Native Client, Microsoft ODBC. Of SQL Server 2008 Native Client failed because a higher version already. Has anyone been able to install Sharepoint 2016 on a fresh Server. Microsoft SQL Server 2012 Native Client. With an RTM or higher version of Server.-. SQL 2012 SP1 Install: Standalone, installed the following for the instance MSSQLSERVER:-Databse Engine Services-SQL Server Replication-Full-Text and Semantic Extractions-Data Quality Services-Reporting Services - Native-SQL Server Data Tools-Intetgration Services-Management Tools -Basica & Complete. Set the SCCM admin as the account to run.

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.

Jan 25, 2020 Here's how you can download the best free music players for your Mac. WMA, MP3, M4V, and dozens more. There’s plenty of focus on video as well, so it also works as an alternative movie player. One thing is, to decide on an effective Android emulator. There are a number of free and paid Android emulators designed for PC, nevertheless we suggest either Bluestacks or Andy as they are known as well as compatible with both of these - Windows (XP, Vista, 7, 8, 8.1, 10) and Mac os. Download To MP3 Converter Free for macOS 10.7 or later and enjoy it on your Mac. ‎To MP3 Converter Free encodes more than 200 audio and video formats to MP3 in one click. Get quality MP3 effortlessly:. Convert audio or video to MP3 in one click. Get the best possible quality of MP3s with auto settings. Transfer tags from source files. Qq music free download - QQ, Music Man, Open Music System (OMS), and many more programs. Burn CDs, and download music to your iPod with Apple's full-featured MP3 solution for Mac OS 9. Free mp3 qq music free for mac. Qq music free download - TubeMate, MP3 Juice - Free MP3 Downloader, TubeMate 3, and many more programs.

Database version →
↓ Driver Version		Azure SQL DatabaseAzure Synapse AnalyticsAzure SQL Managed InstanceSQL Server 2019SQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012SQL Server 2008 R2SQL Server 2008SQL Server 2005
17.6YesYesYesYesYesYesYesYes
17.5YesYesYesYesYesYesYesYes
17.4YesYesYesYesYesYesYesYes
17.3YesYesYesYesYesYesYesYesYesYes
17.2YesYesYesYesYesYesYesYesYes
17.1YesYesYesYesYesYesYesYesYes
17.0YesYesYesYesYesYesYesYesYes
13.1YesYesYesYesYesYes
13YesYesYesYesYes
11YesYesYesYesYes

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 2019Windows Server 2016Windows Server 2012 R2Windows Server 2012Windows Server 2008 R2Windows 10Windows 8.1Windows 7Windows Vista SP2
17.6YesYesYesYesYesYes
17.5YesYesYesYesYesYes
17.4YesYesYesYesYesYesYesYes
17.3YesYesYesYesYesYesYesYes
17.2YesYesYesYesYesYesYes
17.1YesYesYesYesYesYesYes
17.0YesYesYesYesYesYesYes
13.1YesYesYesYesYesYesYes
13YesYesYesYes
11YesYesYesYes

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. How to a video from facebook on mac os. 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

Installation Of Microsoft Sql Server Native Client Failed Because A Higher Version

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.

Sql Server Native Client 11.0 Odbc Driver

Components of the Microsoft ODBC Driver for SQL Server on Windows

Microsoft Sql Server 2012 Native Client

The ODBC driver on Windows contains the following components:

ComponentDescription
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.hThe 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.
Client

See also