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.Its components include: Active X Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC).The Super Socket Net-Lib deals with inter-computer communications and coordinates the secondary Net-Libs – though the TCP/IP secondary Net-Lib is an exception in that it calls on the Windows Socket 2 API directly.
MDAC architecture may be viewed as three layers: a programming interface layer, consisting of ADO and ADO.
NET, a database access layer developed by database vendors such as Oracle and Microsoft (OLE DB, .
NET for data access, the benefit being that users of the application program are not constrained in their choice of database architecture except that it should be supported by MDAC.
Naturally, developers still have the choice of writing applications which directly access OLE DB and ODBC.
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.
NET managed providers and ODBC drivers), and the database itself.
These component layers are all made available to applications through the MDAC API.
OLE DB (also called OLEDB or OLE-DB) allows MDAC applications access to different types of ([data]) stores in a uniform manner.
Microsoft has used this technology to separate the application from data can store in the website the data store that it needs to access.
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).