Client Data Access Technologies

The question of which data access technology to use with SQL Server 2014 is a common one, with a seemingly easy answer: You use SNAC because it has all the latest 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 functionality ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.