This Microsoft Data Access Components (MDAC) release manifest is for the Internet release of MDAC 2.7, referred to as MDAC 2.7 Refresh (2.70.9001.0).
For information about installing, uninstalling, upgrading, and downgrading MDAC releases, visit the following Microsoft Developer Network (MSDN) Web site:
For information about downloading MDAC releases, visit the following MSDN Web site:
Release date and version number
MDAC 2.70 (2.70.9001.0), April 2002
This release provides the same version of MDAC that was released with Microsoft Windows XP. The only difference between the stand-alone Web release of MDAC and the version that was included with the operating system is the version number.
Release ship vehicle
Microsoft Universal Data Access Web site
MDAC 2.7 Refresh (2.70.9001.0) is available in U.S. English, Chinese (Traditional and Simplified), German, Japanese, Korean, Brazilian Portuguese, Czech, Danish, Greek, Slovak, Slovenian, Spanish, Finnish, French, Hungarian, Italian, Dutch, Norwegian, Polish, Portuguese, Russian, Swedish, and Turkish. Note
Hebrew and Arabic are not available in a stand-alone redistributable package. These languages are only available through Windows XP.
Minimum supported configuration
- Microsoft Windows 98 with the Y2K Update 2 and Microsoft Internet Explorer 4.01 Service Pack 2 (SP2) or later
- Microsoft Windows 98 Second Edition
- Microsoft Windows Millennium Edition
- Microsoft Windows NT 4.0 Service Pack 5 (or later) and Internet Explorer 4.01 SP2 or later
- Microsoft Windows 2000
- Microsoft Windows XP
No installation support for the stand-alone release is offered for the Windows XP operating system because this same version of MDAC is included with Windows XP. It is best to obtain MDAC service packs for Windows XP through operating system service pack releases.
The major functionality that is added with this release is support for 64-bit operating systems.
Frequently asked questions about MDAC 2.7
- Q1: Where can a user find specific Microsoft Knowledge Base (KB) articles for the original release version of MDAC 2.7?
A1: You can search the Microsoft Knowledge Base for the original release version by using the "kbmdac270" keyword. To search the Microsoft Knowledge Base, visit the following Microsoft Web site:Note In the Search results list, search only for articles that have specific technical information about the original release version, not for bug-related issues.
- Q2: Where can a user find more information about MDAC setup, including dependencies, supported operating systems, and rollback?
A2: For more information about MDAC 2.7 setup, visit the following Microsoft Web site
842193:Note This article was orignally authored for MDAC 2.6. However, the article still applies to MDAC 2.7.
Frequently asked questions about MDAC 2.6 and MDAC 2.7 Setup
- Q3: An application requires Microsoft Jet, but Jet is no longer included in MDAC. Where can a user obtain Jet?
A3: The Microsoft Jet components were removed from MDAC 2.6 and are not included with MDAC 2.7. For additional information about the issues involving Jet, click the following article number to view the article in the Microsoft Knowledge Base:
271908Note This article discusses the changes that were made in MDAC 2.6 regarding the Jet components.
MDAC Version 2.6 and later do not contain Jet or Desktop ODBC Drivers
- Q4: An application requires the Microsoft Visual FoxPro ODBC Driver, but it is no longer included in MDAC. Where can a user obtain the Visual FoxPro ODBC Driver?
A4: The Visual FoxPro ODBC driver is included with Microsoft Visual FoxPro, Microsoft Windows 2000, Microsoft Office 2000, and MDAC 2.5. It is not included with MDAC 2.7 or with Windows XP.
Known issues in MDAC 2.70 (2.70.9001.0)
This MDAC release contains the following known issues:
- Versioning problems with clustered servers
If a clustered server is running Microsoft SQL Server 6.5 or SQL Server 7.0, installing MDAC 2.6 or MDAC 2.7 on that clustered server causes connectivity problems in the whole cluster. There is currently no workaround. Do not install MDAC 2.6 or MDAC 2.7 on a clustered server if it is running SQL Server 6.5 or SQL Server 7.0. There is no problem with SQL Server 2000 clusters using MDAC 2.6 or MDAC 2.7. There is no problem using MDAC 2.7 on a client that is connecting to a SQL Server 6.5 clustered server or a SQL Server 7.0 clustered server.
- DSN issues
When you create or configure ODBC data source names (DSNs) by using the SQL Server ODBC driver, the following issues might occur:
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
- Net-Library protocols might be switched.
- A new DSN protocol might be used for older DSNs or vice versa.
PRB: Configuring DSNs with SQL Server Net-libraries
- Connectivity issue with Windows XP
After you install Windows XP on your computer, you might experience difficulty establishing a connection to your server computer that is running SQL Server. The difficulty occurs when the network libraries check the certificates on your computer. Remove the certificates from your computer, or install SQL Server Service Pack 1, and then apply a registry key that prevents certificate validation. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
PRB: SQL Server 2000 installation or local connections fail with "SSL Security error :ConnectionOpen (SECDoClientHandshake())" error message
- Analysis Services 2000 issues
You might not be able to browse cubes or process mining models after you install the original release version of Analysis Services 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
FIX: Cannot browse cubes or process mining model after you Install Analysis Services 2000 RTM
- Connection to SQL Server fails after you install MDAC 2.6 or MDAC 2.7
The default network library for connecting to SQL Server has changed. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
PRB: Configuring DSNs with SQL Server Net-Libraries
- Support for Banyan Vines
The earlier versions of MDAC supported the Banyan Vines network protocol. Starting with MDAC 2.7, this support has been dropped from the product. The source of this problem is that Banyan Vines does not support Windows XP. The Banyan Vines file is included with MDAC 2.7 and installs on Windows 2000 and earlier. The file is also included with Windows XP Professional, but you cannot use the file on that operating system.
- Nested transaction errors
If you experience errors when you implement nested transaction with the OLE DB Provider for SQL Server, these errors might be caused by the settings for XACT_ABORT. For additional information about this issue and the resolution to this issue, click the following article number to view the article in the Microsoft Knowledge Base:
PRB: Error when you implement nested transaction with OLE DB Provider for SQL Provider
- MSXML3 and 64-bit installations
There are some differences between installing the MSXML3.dll file on a 64-bit system and on a 32-bit system. Specifically, the MSXLM3.dll file is installed in full replace mode on a 64-bit system. Side-by-side mode is the default mode for 32-bit systems. For additional information about the differences between side-by-side and full replace mode, click the following article number to view the article in the Microsoft Knowledge Base:
INFO: Installation of MSXML parser affects Run mode
- Over-localized ODBC Driver names in the ODBC Administrator’s drivers tab
In older versions of Microsoft Office, the Windows installer incorrectly looks for localized ODBC driver names. Therefore, many of the ODBC drivers have been localized into French, German, and Portuguese. Do not under any circumstances use or reference these drivers by any other program. These drivers will be removed from future versions of the MDAC components and from future versions of Windows.
- Problem with Windows rollback
On a computer that is running Windows 98 or Windows Millennium Edition, if you try to roll your installation back to an earlier version, your computer will be left in a mixed state where your files will not all be from the same version of MDAC. This is caused by a problem with the setup technology that is included with this version of the operating system. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
PRB: MDAC Rollback may fail on Windows 95, Windows 98, and Windows Millennium Edition
- File list differences between 32-bit and 64-bit installations
The following 32-bit MDAC files are not installed on the 64-bit MDAC installation.
|dbmsgnet.dll ||dbmsrpcn.dll ||dbmssnet.dll ||dbmsvinn.dll |
|dbrstprx.dll ||ds16gt.dll ||mscpx32r.dll ||mscpxl32.dll |
|msdadc.dll ||msdaenum.dll ||msdaer.dll ||msdaora.dll |
|msdaorar.dll ||msdasc.dll ||msdatt.dll ||msdaurl.dll |
|msjro.dll ||msorc32r.dll ||msorcl32.dll ||odbc16gt.dll |
- Backward compatibility libraries for 64-bit
No backward compatibility libraries are included with the 64-bit operating system. These libraries were removed from the 64-bit operating system intentionally because there are no older versions of MDAC that run on a 64-bit operating system. The following files have been removed: msado20.tlb, msado21.tlb, msado25.tlb, msado26.tlb.
- Running the 2.6 or 2.7 MDAC_TYP.exe on a computer that is running Windows XP
If you try to run the MDAC 2.6 MDAC_TYP.exe file or the MDAC 2.7 MDAC_TYP.exe file on Windows XP, the process appears to complete successfully, and a successful installation of the MDAC components is reported. However, no files are updated on your system. If you want to upgrade Windows XP to a new service pack level of the MDAC components, it is best to obtain the Windows XP service pack release. This release will contain the new service pack level of MDAC.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Significant fix for MDAC 2.7 Refresh (2.70.9001.0)
This refresh release contains the following significant fix since the original release version of MDAC 2.70.
- Reversion of the 2.7 stack from 2.70.7713.2 to 2.70.9001.0
This change was made to allow the MDAC 2.7 Refresh to correctly install on top of the MDAC 2.62 release. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
INFO: Explanation of the MDAC 2.7 Refresh release
File list for MDAC 2.7 RTM (2.70. 9001.0) 32-bit
|File name||Version (x86)||Description|
|cliconfg.dll ||2000.80.380.0 ||Client Configuration Utility |
|cliconfg.exe ||2000.80.380.0 ||Client Configuration Utility |
|cliconfg.rll ||2000.80.380.0 ||Client Configuration Utility |
|DBmsadsn.dll ||2000.81.9001.0 ||ADSP Net Library |
|DBmsgnet.dll ||2000.81.9001.0 ||Winsock Oriented Net Library |
|DBmslpcn.dll ||2000.81.9001.0 || Local IPC Net Library |
|DBmsrpcn.dll ||2000.81.9001.0 ||RPC Net Library |
|DBmssnet.dll ||2000.81.9001.0 ||Sockets Net Library |
|DBmsvinn.dll ||2000.81.9001.0 ||VINES Net Library |
|DBnetlib.dll ||2000.81.9001.0 ||Winsock Oriented Net DLL |
|dbrstprx.dll ||2.70.9001.0 ||OLE DB Interface Remoting Stub |
|ds16gt.dll ||3.510.3711.0 ||ODBC 16-bit Driver Setup Generic Thunking |
|DS32GT.dll ||3.520.9001.0 ||ODBC Driver Setup Generic Thunking |
|expsrv.dll ||188.8.131.5240 ||Expression Service |
|mdac_typ.exe ||27.0.9001.0 ||Installation Package |
|msadce.dll ||2.70.9001.0 ||OLE DB Cursor Engine |
|msadcer.dll ||2.70.9001.0 ||OLE DB Cursor Engine Resources |
|msadcf.dll ||2.70.9001.0 ||Remote Data Services Data Factory |
|msadcfr.dll ||2.70.9001.0 ||Remote Data Services Data Factory Resources |
|msadco.dll ||2.70.9001.0 ||Remote Data Services Data Control |
|msadcor.dll ||2.70.9001.0 ||Remote Data Services Data Control Resources |
|msadcs.dll ||2.70.9001.0 ||Remote Data Services ISAPI Library |
|msadds.dll ||2.70.9001.0 ||OLE DB Data Shape Provider |
|msaddsr.dll ||2.70.9001.0 ||OLE DB Data Shape Provider Resources |
|msader15.dll ||2.70.9001.0 ||ADO Resources |
|msado15.dll ||2.70.9001.0 ||ADO |
|msado20.tlb ||2.70.9001.0 ||ADO 2.0 Type Library |
|msado21.tlb ||2.70.9001.0 ||ADO 2.1 Type Library |
|msado25.tlb ||2.70.9001.0 ||ADO 2.5 Type Library |
|msado26.tlb ||2.70.9001.0 ||ADO 2.6 Type Library |
|msadomd.dll ||2.70.9001.0 ||ADO MD |
|msador15.dll ||2.70.9001.0 ||ADO |
|msADOX.dll ||2.70.9001.0 ||ADO Extensions |
|msadrh15.dll ||2.70.9001.0 ||ADO Rowset Helper |
|mscpx32r.dll ||3.520.9001.0 ||ODBC Code Page Translator Resources |
|mscpxl32.dll ||3.520.9001.0 ||ODBC Code Page Translator |
|msdadc.dll ||2.70.9001.0 ||OLE DB Data Conversion Stub |
|msdaenum.dll ||2.70.9001.0 ||OLE DB Root Enumerator Stub |
|msdaer.dll ||2.70.9001.0 ||OLE DB Error Collection Stub |
|msdamg9x.dll ||2.70.9001.0 ||Win98 Migration DLL |
|msdaora.dll ||2.70.9001.0 ||OLE DB Provider for Oracle |
|msdaorar.dll ||2.70.9001.0 ||OLE DB Provider for Oracle Resources |
|MSDAOSP.dll ||2.70.9001.0 ||OLE DB Simple Provider |
|msdaprsr.dll ||2.70.9001.0 ||OLE DB Persistence Services Resources |
|msdaprst.dll ||2.70.9001.0 ||OLE DB Persistence Services |
|msdaps.dll ||2.70.9001.0 ||OLE DB Interface Proxies/Stubs |
|msdarem.dll ||2.70.9001.0 ||OLE DB Remote Provider |
|msdaremr.dll ||2.70.9001.0 ||OLE DB Remote Provider Resources |
|msdart.dll ||2.70.9001.0 ||OLE DB Runtime Routines |
|msdasc.dll ||2.70.9001.0 ||OLE DB Service Components Stub |
|msdasql.dll ||2.70.9001.0 ||OLE DB Provider for ODBC Drivers |
|msdasqlr.dll ||2.70.9001.0 ||OLE DB Provider for ODBC Drivers Resources |
|msdatl3.dll ||2.70.9001.0 ||OLE DB Implementation Support Routines |
|msdatt.dll ||2.70.9001.0 ||OLE DB Temporary Table Services |
|msdaurl.dll ||9.1.9001.0 ||OLE DB RootBinder Stub |
|msdfmap.dll ||2.70.9001.0 ||Data Factory Handler |
|msjro.dll ||2.70.9001.0 ||Jet and Replication Objects |
|msjtes40.dll ||4.0.2927.8 ||Jet Expression Service |
|msorc32r.dll ||2.573.9001.0 ||ODBC Driver for Oracle Resource Library |
|msorcl32.dll ||2.573.9001.0 ||ODBC Driver for Oracle |
|msvcirt.dll ||6.0.8168.0 ||(R) C++ Runtime Library |
|msvcrt.dll ||6.0.8397.0 ||(R) C Runtime Library |
|mswdat10.dll ||4.0.3829.2 ||Jet Sort Tables |
|mswstr10.dll ||4.0.3829.2 ||Jet Sort Library |
|msxactps.dll ||2.70.9001.0 ||OLE DB Transaction Proxies/Stubs |
|msxml3.dll ||8.20.8730.1 ||MSXML3 |
|msxml3a.dll ||8.20.8730.1 ||MSXML3 Resource file |
|msxml3r.dll ||8.20.8730.1 ||MSXML3 Resource file |
|mtxdm.dll ||1999.6.902.0 ||MTS connection pooling - ODBC driver manager |
|mtxoci.dll ||1999.6.854.0 ||MTS - Oracle OCI |
|odbc16gt.dll ||3.510.3711.0 ||ODBC 16-bit Generic Thunking |
|ODBC32.dll ||3.520.9001.0 ||ODBC Driver Manager |
|ODBC32GT.dll ||3.520.9001.0 ||ODBC Driver Generic Thunking |
|odbcad32.exe ||3.520.9001.0 ||ODBC Administrator |
|odbcbcp.dll ||2000.81.9001.0 ||SQL Server ODBC Driver BCP Library |
|odbcconf.dll ||3.520.9001.0 ||ODBC Driver Configuration Program |
|odbcconf.exe ||3.520.9001.0 ||ODBC Driver Configuration Program |
|ODBCCP32.cpl ||3.520.9001.0 ||ODBC Control Panel |
|ODBCCP32.dll ||3.520.9001.0 ||ODBC Installer |
|ODBCCR32.dll ||3.520.9001.0 ||ODBC Cursor Library |
|ODBCCU32.dll ||3.520.9001.0 ||ODBC Cursor Library |
|ODBCINT.dll ||3.520.9001.0 ||ODBC Resources |
|ODBCP32R.dll ||3.520.9001.0 ||ODBC Control Panel Resources |
|ODBCTRAC.dll ||3.520.9001.0 ||ODBC Driver Manager Trace |
|oledb32.dll ||2.70.9001.0 ||OLE DB Core Services |
|oledb32a.dll ||2.70.9001.0 ||OLE DB Core Services ANSI Resources |
|oledb32r.dll ||2.70.9001.0 ||OLE DB Core Services Resources |
|oledbvbs.inc ||n/a ||OLE DB VBS include file |
|psapi.dll ||4.0.1371.1 ||Process Status Helper |
|sqloledb.dll ||2000.81.9001.0 ||OLE DB Provider for SQL Server |
|sqloledb.rll ||2000.81.9001.0 ||OLE DB Provider for SQL Server Resource Library |
|SQLSRV32.dll ||2000.81.9001.0 ||SQL Server ODBC Driver |
|SQLSRV32.rll ||2000.81.9001.0 ||SQL Server ODBC Driver Resource Library |
|sqlunirl.dll ||2000.80.380.0 ||SQL Server Unicode Resource Layer Library |
|sqlxmlx.dll ||2000.80.382.0 ||XML extensions for SQL Server |
|sqlxmlx.rll ||2000.80.382.0 ||XML extensions for SQL Server Resource Library |
|vbajet32.dll ||184.108.40.20668 ||Expression Service Loader |