DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 842280 - Last Review: March 20, 2007 - Revision: 2.6

On This Page

SUMMARY

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:
http://msdn2.microsoft.com/en-us/library/ms810805.aspx (http://msdn2.microsoft.com/en-us/library/ms810805.aspx)
For information about downloading MDAC releases, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx (http://msdn2.microsoft.com/en-us/data/aa937730.aspx)

Release date and version number

MDAC 2.70 (2.70.9001.0), April 2002

Release function

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
http://msdn2.microsoft.com/en-us/data/aa937695.aspx (http://msdn2.microsoft.com/en-us/data/aa937695.aspx)

Localization information

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.

New features

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:
    http://support.microsoft.com/gp/gsssearchhelp (http://support.microsoft.com/gp/gsssearchhelp)
    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  (http://support.microsoft.com/kb/842193/ ) Frequently asked questions about MDAC 2.6 and MDAC 2.7 Setup
    :Note This article was orignally authored for MDAC 2.6. However, the article still applies to MDAC 2.7.
  • 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:
    271908  (http://support.microsoft.com/kb/271908/ ) MDAC Version 2.6 and later do not contain Jet or Desktop ODBC Drivers
    Note This article discusses the changes that were made in MDAC 2.6 regarding the Jet components.
  • 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:
    • Net-Library protocols might be switched.
    • A new DSN protocol might be used for older DSNs or vice versa.
    For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
    289573  (http://support.microsoft.com/kb/289573/ ) 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:
    309398  (http://support.microsoft.com/kb/309398/ ) 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:
    297232  (http://support.microsoft.com/kb/297232/ ) 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:
    289573  (http://support.microsoft.com/kb/289573/ ) 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:
    306649  (http://support.microsoft.com/kb/306649/ ) 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:
    303207  (http://support.microsoft.com/kb/303207/ ) 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:
    311720  (http://support.microsoft.com/kb/311720/ ) 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.
    Collapse this tableExpand this table
    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:
    320778  (http://support.microsoft.com/kb/320778/ ) INFO: Explanation of the MDAC 2.7 Refresh release

File list for MDAC 2.7 RTM (2.70. 9001.0) 32-bit

Collapse this tableExpand this table
File nameVersion (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 6.0.0.8540 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
oledbjvs.inc n/a OLE DB JavaScript include file
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 6.0.1.8268 Expression Service Loader

APPLIES TO
  • Microsoft Data Access Components 2.7
Keywords: 
kbinfo KB842280
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support