I have a web application with a MS SQL 2012R2 Server in the back end.
If we connect to the server with our connection string using 'SQL Server' then the system works fine, but we cannot disable TLS 1.1 because apparently this driver uses that version. Driver

Info, examples and downloads for 'SQL Server Native Client 11.0 ODBC Driver'. Connection string options and links to more detailed resources. SQL Server Native Client 11.0 download for Windows 7 32 bit It is suppose to work. After searching an hour, MS claims it can be installed as part of the new SQL Server in one of the directories.

If we connect to the server using SQL Server Native Client 11.0 then we can disable TLS 1.1 and use TLS 1.2 only, BUT then certain fields from our database such as text fields, nvarchar(max), and apparently any long strings won't work anymore. The data is not displayed in the ASP files and some other errors are displayed in the application.
What is causing this with the 11.0 connection and how can we fix it?

Where to download the ODBC Drivers and OLEDB Providers for the different versions of SQL Server Native Client?

Odbc Sql Server Driver

There are different versions of the Native Client components for each SQL Server.

SQL Server 2005 - Native Client 9.0
SQL Server 2008 - Native Client 10.0
SQL Server 2012 - Native Client 11.0

The components have been distributed through SQL Server 'Feature Packs' and there are new versions of those 'Feature Packs' for each Service Pack release of SQL Server.

This page lists instructions and download links for each version of the Native Client OLE DB providers and ODBC drivers and for each Feature Pack distribution package. If you find something is missing, let us know here!

Download SQL Server 2005 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within the 'Feature Pack for Microsoft SQL Server 2005'.
There are four versions of this Feature Pack. The latest is the 'December 2008' package.

The package contains:

SQL Native Client 9.0 OLE DB Provider - 'SQLNCLI'
SQL Native Client 9.0 ODBC Driver - '{SQL Native Client}'

Download Instructions

First navigate to one of the download links below, then:

Hit Download button.
Checkbox one of the installation packages (msi). Make sure you choose the right version:
- sqlncli.msi for 32-bit
- sqlncli_x64.msi for 64-bit
- sqlncli_ia64.msi for Itanium
Click Next.
Download starts.

Feature Pack for SQL Server 2005 - download links

Download SQL Server 2008 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within Microsoft SQL Server 2008 'Feature Packs'.
There are different 'Feature Packs' for each SQL Server 2008 service pack version.

The package contains:

SQL Server Native Client 10.0 OLE DB Provider - 'SQLNCLI10'
SQL Server Native Client 10.0 ODBC Driver - '{SQL Server Native Client 10.0}'

Download Instructions

First navigate to one of the download links below, then:

Hit Download button.
Checkbox one of the 'sqlncli.msi' installation packages. Make sure you choose the right version:
- x86 for 32-bit
- x64 for 64-bit
- IA64 for Itanium
Click Next.
Download starts.

Feature Pack for SQL Server 2008 - download links

SQL Server 2008 SP1 Feature Pack - NO LONGER AVAILABLE
SQL Server 2008 Feature Pack - NO LONGER AVAILABLE

Download SQL Server 2008 R2 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within Microsoft SQL Server 2008 R2 'Feature Packs'.
There are different 'Feature Packs' for each SQL Server 2008 R2 service pack version.

The package contains:

SQL Server Native Client 10.0 OLE DB Provider - 'SQLNCLI10'
SQL Server Native Client 10.0 ODBC Driver - '{SQL Server Native Client 10.0}'

Download Instructions

First navigate to one of the download links below, then:

Hit Download button.
Checkbox one of the 'sqlncli.msi' installation packages. Make sure you choose the right version:
- sqlncli_x86.msi for 32-bit
- sqlncli_amd64.msi for 64-bit
- sqlncli_ia64.msi for Itanium
Click Next.
Download starts.

Feature Pack for SQL Server 2008 R2 - download links

Download SQL Server 2012 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within the 'Microsoft SQL Server 2012 Feature Pack'.
There are currently only one 'Feature Pack' for SQL Server 2012.

The package contains:

SQL Server Native Client 11.0 OLE DB Provider - 'SQLNCLI11'
SQL Server Native Client 11.0 ODBC Driver - '{SQL Server Native Client 11.0}'

Download Instructions

First navigate to one of the download links below, then:

Sql Server Native Client 11.0 Download

Do NOT hit the Download button
Expand the 'Install Instructions' section
Scroll down to the 'MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS' section (it's far down)
Under the 'Microsoft SQL Server 2012 Native Client' heading, click one of the 'sqlncli.msi' installation package links. Make sure you choose the right version:
- X86 Package for 32-bit
- X64 Package for 64-bit
- seems there are no link for the Itanium CPU architecture
Download starts.

Sql Server Native Client 11 Driver Download

Feature Pack for SQL Server 2012 - download links

Summary

This page aims to provide all information needed to obtain the correct Native Client ODBC Driver or Native Client OLEDB Provider for connections to SQL Server. If any info on this page is not up to date, not correct, unclear or could be more precise, let us know buy sending us info through this form. Thanks!