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.
dating linkex - Updating a sql recordset
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.
The primary Net-Lib consists of a Super Socket Net-Lib and the Shared Memory Net-Lib, while there are numerous secondary Net-Libs, including TCP/IP and named pipes network libraries (named pipes are a method of communicating with other processes via a system-persistent pipeline that is given an identity).
The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) communicates via primary Net-Libs.
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, .Later Microsoft released upgrades to MDAC as web-based redistributable packages.Eventually, later versions were integrated with Microsoft Windows and Internet Explorer, and in MDAC 2.8 SP1 they ceased offering MDAC as a redistributable package.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.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.