Q2: What versions of SQL Server does SQL Native Client support?

Q3: Why would I move from MDAC (either the SQL ODBC driver or the SQL OLEDB provider)?

A3: SQL Native Client can be used to create new
applications or enhance existing applications that need to take advantage of
new SQL Server 2005 features such as Multiple Active Result Sets (MARS),
user-defined data types (UDT), query notifications, snapshot isolation, and XML
data type support.

Q4: Where can I find documentation for SQL Native Client?

A4: SQL Native Client documentation is available in the
“SQL Server Programming Reference” section of the SQL Server 2005 Books Online.
SQL Server 2005 Books Online can be viewed in the MSDN Library, available for
download on
http://www.microsoft.com/downloads

(http://www.microsoft.com/downloads)

and is
optionally installed with Microsoft SQL Server 2005.

Q5: Does SQL Native Client require MDAC and if so what version?

A5: The SQL Native Client ODBC driver is always used in
conjunction with the ODBC Driver Manager supplied with MDAC. The SQL Native
Client OLE DB provider may be used in conjunction with OLE DB Core Services
supplied with MDAC, but this is not a requirement – the choice to use Core
Services or not depends on the requirements of the individual application (for
example, if connection pooling is required). SQL Native Client uses the version of MDAC supplied
by the operating system.

File list for SQL Native Client (9.00.1399.06)

Collapse this tableExpand this table

File Name

Version (x86)

Description

Sqlncli.dll

2005.90.1399.0

The dynamic-link
library (DLL) file that contains all of the SQL Native Client functionality.
This includes the SQL Native Client OLE DB provider and the SQL Native Client
ODBC driver.

Sqlnclir.rll

2005.90.1399.0

SQL Native Client
resource file.

Sqlncli.chm

The Data Source Wizard help file
that documents how to create a SQL Server data source using the SQL Native
Client ODBC driver or the SQL Native Client OLE DB provider.