SQL Server Native Client 10.0 OLE DB Provider

This OLE DB Provider is provided by Microsoft. The main functionality of the provider is contained in the file sqlncli10.dll.

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

Description

SQL Server Native Client version 10 was released with SQL Server 2008.

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 10.0 provides OLE DB support to applications connecting to SQL Server versions 2000, 2005, 2008 and 2008R2.

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

This OLE DB Provider, SQL Server Native Client 10.0 OLE DB Provider, can be downloaded here.

Connection Strings

The SQL Server Native Client 10.0 OLE DB Provider provider can be used to connect to the following data sources by using the following connection string references:

SQL ServerSQL Server 2008SQL Server 2005SQL Server 2000SQL Server 7.0Azure SQL Database

Providers

.NET Framework Data Provider for SQL Server Microsoft SqlClient Data Provider for SQL Server SQL Server Native Client 10.0 ODBC Driver SQL Native Client 9.0 OLE DB Provider SQL Native Client 9.0 ODBC Driver SQL Server Native Client 11.0 OLE DB Provider SQL Server Native Client 11.0 ODBC Driver Microsoft ODBC Driver 11 for SQL Server Microsoft OLE DB Provider for SQL Server Microsoft ODBC Driver 17 for SQL Server Microsoft ODBC Driver 13 for SQL Server Microsoft SQL Server ODBC Driver Microsoft OLE DB Driver for SQL Server .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC SQLXML 4.0 OLEDB Provider SQLXML 3.0 OLEDB Provider Context Connection MSDataShape

Articles

read all »
Application Name for SQL Server Connections All SQL Server SqlConnection Properties The new Microsoft.Data.SqlClient explained SQL Server Data Types Reference When to use the SQL Native Client Network Protocol for SQL Server Connection Download SQL Server Native Client SQL Server 2005 Data Types Reference SQL Server 2008 Data Types Reference SQL Server 2000 Data Types Reference