SQL Server Native Client 10.0 ODBC Driver

This ODBC Driver is provided by Microsoft. The main functionality of the driver is contained in the file sqlncli10.dll.

Include "Driver={SQL Server Native Client 10.0}" in the connection string to use this driver.

Description

The SQL Server Native Client 10.0 ODBC Driver was released with SQL Server 2008 and can access SQL Servers from 7.0 and above.

Programs that are written using the SQL Native Client ODBC driver communicate with SQL Server through function calls. The SQL Server-specific versions of the ODBC functions are implemented in the SQL Native Client ODBC driver. The driver passes SQL statements to SQL Server and returns the results of the statements to the application. The SQL Native Client driver supports connecting to SQL 7.0 and later.

The driver is included in the "Microsoft SQL Server 2008 Feature Pack". Search for it to make sure you download the latest release (new releases comes quite often).

The SQL Native Client ODBC driver complies with the Microsoft Win32 ODBC 3.51 specification. The driver supports applications written using earlier versions of ODBC in the manner defined in the ODBC 3.51 specification.

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

Download

This ODBC Driver, SQL Server Native Client 10.0 ODBC Driver, can be downloaded here.

Connection Strings

The SQL Server Native Client 10.0 ODBC Driver driver 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 OLE DB Provider 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