Error creating updating the odbc dsn
The current version is 2.8 service pack 1, but the product has had many different versions and many of its components have been deprecated and replaced by newer Microsoft technologies. The latest version of MDAC (2.8) consists of several interacting components, all of which are Windows specific except for ODBC (which is available on several platforms).
Each Net-Lib supported network protocol has a separate driver (not to be confused with a device driver), and has support for a session layer in its protocol stack.
There are two general types of Net-Lib: the primary and the secondary.
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.
The Microsoft SQL Server Network Library, a proprietary access method specific to Microsoft SQL Server, is also included in the MDAC.
MDAC architecture may be viewed as three layers: a programming interface layer, consisting of ADO and ADO.
Its components include: Active X Data Objects (ADO), OLE DB, and Open Database Connectivity (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.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.The Banyan VINES, Apple Talk, Server Net, IPX/SPX, Giganet, and RPC Net-Libs were dropped from MDAC 2.5 onwards.Throughout its history, MDAC has been the subject of several security flaws, which led to attacks such as an escalated privileges attack, although the vulnerabilities were generally fixed in later versions and fairly promptly.