December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Connecting Using the Various Providers and Drivers
Now that you know what your options are in terms of providers and drivers, the following sections detail them one by one, with a special focus on putting the features in SQL Server 2012 to work.
Using SNAC
SNAC is a net-library that contains both the latest OLE DB provider and ODBC provider for using the rich features in SQL Server 2012 databases. It is compatible for accessing SQL Server 7, 2000, 2005, and 2008 databases as well.
The code for SNAC is contained in the single dynamic link library sqlncli11.dll, and it serves as provider, driver, and API for applications that call its underlying COM functions from unmanaged code (that is, from C or C++).
The bottom line with SNAC is that if you’re ...