O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Native Client (SNAC)

SQL Native Client, also known as SNAC (pronounced to rhyme with "lack"), is a data access technology new in Microsoft SQL Server 2005. SNAC is a stand-alone data access application programming interface (API) that combines the SQL OLE DB provider and the ODBC driver into one native dynamic-link library (SQLNCLI.DLL) while also providing new functionality above and beyond that supplied by the Microsoft Data Access Components (MDAC).

It is a common misconception that the SQL Native Client replaces MDAC. This is absolutely not true; MDAC is still fully supported. The big difference between SNAC and MDAC is that unlike earlier editions, SQL Server 2005 does not distribute the MDAC library. Instead, it ships the SNAC library, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required