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.