The OLE DB Driver for SQL Server names are different from names used with MDAC. The publicly exposed interfaces have been kept to a minimum, both to ease distribution, as well as to limit security exposure. OLE DB Driver for SQL Server is a single self-contained dynamic link library (DLL) file.
#GET MDAC VERSION UPDATE#
With MDAC, the update was accepted but ignored. If an ADO application uses OLE DB Driver for SQL Server and attempts to update a computed column, an error will be reported. Users who use ADO to access the OLE DB Driver for SQL Server may find less filtering functionality than when they accessed the SQL OLE DB provider. OLE DB Driver for SQL Server and MDAC differ in the other following areas: In addition, although MDAC contains components for using OLE DB, ODBC, and ActiveX Data Objects (ADO), OLE DB Driver for SQL Server only implements OLE DB (although ADO can access the functionality of OLE DB Driver for SQL Server). Although both provide native data access to SQL Server databases, OLE DB Driver for SQL Server has been designed to expose the new features of SQL Server, while at the same time maintaining backward compatibility with earlier versions. There are a number of differences between OLE DB Driver for SQL Server and Microsoft Data Access Components (MDAC) starting with Windows Vista, the data access components are now called Windows Data Access Components (or Windows DAC).
Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)