Updating remote sql database with dbase

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.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.

Naturally, developers still have the choice of writing applications which directly access OLE DB and ODBC.

The Microsoft SQL Server Network Library (also known as Net-Lib) is used by the Microsoft SQL Server to read and write data using many different network protocols.

The Banyan VINES, Apple Talk, Server Net, IPX/SPX, Giganet, and RPC Net-Libs were dropped from MDAC 2.5 onwards.

The Network Library router had the job of managing all these protocols, however now only the named pipes secondary Net-Lib is managed by the router.

Though Net-Lib is specific to the SQL Server, Microsoft includes it with MDAC.

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.

The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) communicates via primary Net-Libs.

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 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).

Comments are closed.