Updating a sql recordset
There have been several deprecated components as well, such as the Microsoft Jet Database Engine, MSDASQL (the OLE DB provider for ODBC), and Remote Data Services (RDS).Some components have also become obsolete, such as the former Data Access Objects API and Remote Data Objects.This was done because different applications need access to different types and sources of data, and do not necessarily need to know how to access technology-specific functionality.The technology is conceptually divided into consumers and providers.The SQL Server uses the Open Data Services (ODS) library to communicate with Net-Lib, which interfaces directly with the Windows NT operating system line's Win32 subsystem.
At that time Microsoft stated MDAC was more a concept than a stand-alone program and had no widespread distribution method.
The Shared Memory Net-Lib, on the other hand, manages connections between multiple instances of SQL Server that exist on one computer.
It uses a shared memory area to communicate between the processes.
This is inherently secure; there is no need for data encryption between instances of SQL Server that exist on one computer as the operating system does not allow any other process access to the instances' area of shared memory.
Net-Lib is also able to support the impersonation of a logged in user's security context for protocols that support authenticated connections (called trusted connections).
Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.