Client Data Access Technologies

The question of which data access technology to use with SQL Server 2012 is a common one, with a seemingly easy answer: You use SNAC because it has all the latest and greatest functionality, all rolled into one. (You learn how to use SNAC in the sections that follow.) A more correct answer is that your choice depends on which software technologies your clients currently use and what their specific needs are.

Your data access options consist of providers and drivers, whose functionality is often encapsulated inside code libraries known as net-libraries (such as SNAC’s sqlncli11.dll). In addition to these net-libraries, supporting services such as MDAC’s OLE DB Core Services are also available, providing useful ...

Get Microsoft® SQL Server 2012 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.