Developers community number 1 connection string reference

SQL Server Native Client 10.0 OLE DB Provider

This is a OLE DB Provider provided by Microsoft.
The provider is contained in the file sqlncli10.dll.
Coding
Include "Provider=SQLNCLI10" in the connection string to use this provider.
Description

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 2008.

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.
Connection Strings
The SQL Server Native Client 10.0 OLE DB Provider provider can be used to connect to the following data sources.

To see the available connection options, navigate to the connection strings reference by clicking the data source link.
SQL Server 2008
SQL Server 2005
SQL Server 2000, 7.0
SQL Azure
Additional info or comments on this provider? Want to submit content?

Send an e-mail to
Copyright © 2012 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.