SQL Server Native Client 11.0 OLE DB Provider

This OLE DB Provider is provided by Microsoft.
The provider is contained in the file sqlncli11.dll.

Coding

Include "Provider=SQLNCLI11" in the connection string to use this provider.

Description

SQL Server Native Client version 11 was released with SQL Server 2012.

The SQL Server Native Client OLE DB provider is a low-level COM API that is used for accessing data. The SQL Server Native Client OLE DB provider is recommended for developing tools, utilities, or low-level components that need high performance. The SQL Server Native Client OLE DB provider is a native, high performance provider that accesses the SQL Server Tabular Data Stream (TDS) protocol directly.

Read more about when to use this provider in the article "When to use the SQL Native Client" in the artices section.

SQL Server Native Client 11.0 provides OLE DB support to applications connecting to SQL Server versions 2005, 2008, 2008R2, 2012.

The SQL Server Native Client OLE DB provider is an OLE DB version 2.0–compliant provider.

More info about this provider can be found at the Microsoft product page.

Download

OLE DB Provider (SQL Server Native Client 11.0 OLE DB Provider) can be downloaded here.

Connection Strings

The SQL Server Native Client 11.0 OLE DB Provider provider can be used to connect to the following data sources:

SQL AzureSQL ServerSQL Server 2012

To see available connection options, navigate to the connection strings reference by the above links.

Not the right library?

Try search the kb articles, Q&A content and every connection string here.

Or go to the Q&A forums where you can ask questions.

Browse every article in the knowledge base. Start over in the connection string reference.

Providers

Articlesread all »