Release manifest for the MDAC 2.7 Service Pack 1 Refresh (2.71.9040.2)

Article translations Article translations
Article ID: 842262
Expand all | Collapse all

Summary

This article describes the release manifest of the Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 (SP1) Refresh and includes the following information about the MDAC 2.7 SP1 Refresh:
  • The minimum configuration requirements for the MDAC 2.7 SP1 Refresh.
  • The frequently asked questions about the MDAC 2.7 SP1 Refresh.
  • The known issues with the MDAC 2.7 SP1 Refresh.
  • The significant fixes for the MDAC 2.7 SP1 Refresh.
  • The list of files that are included in the MDAC 2.7 SP1 Refresh and the versions of these files.

INTRODUCTION

This release manifest applies to the Internet release of the MDAC 2.7 SP1 Refresh (2.71.9040.2). This release manifest lists frequently asked questions about the MDAC 2.7 SP1 Refresh and describes known issues with the MDAC 2.7 SP1 Refresh. This release manifest also lists all the files that are included in the MDAC 2.7 SP1 Refresh, and this manifest lists the corresponding versions of these files.

For more information about installing, removing, upgrading, and downgrading MDAC releases, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms810805.aspx
For more information about downloading MDAC releases, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx

More information

Release version number

MDAC 2.7 SP1 Refresh (2.71.9040.2), May 2003

Release function

This release provides almost the same version of MDAC that was released with Microsoft Windows XP Service Pack 1 (SP1). The difference between the stand-alone Web release of MDAC and the version that is included as part of the operating system is that the stand-alone Web release of MDAC contains updated versions of the following files:
  • Dbnetlib.dll
  • Msdart.dll
  • Odbcbcp.dll
  • Oledb32.dll
  • Sqloledb.dll
  • Sqlsrv32.dll
  • Sqlunirl.dll

Release ship vehicle

To download the MDAC 2.7 SP1 Refresh (2.71.9040.2), visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/data/aa937695.aspx

Localization information

The MDAC 2.7 SP1 Refresh (2.71.9040.2) is available in the following languages:
  • U.S. English
  • Arabic
  • Brazilian Portuguese
  • Czech
  • Chinese (Traditional and Simplified)
  • Danish
  • Dutch
  • Finnish
  • French
  • German
  • Greek
  • Hebrew
  • Hungarian
  • Italian
  • Japanese
  • Korean
  • Norwegian
  • Polish
  • Portuguese
  • Russian
  • Slovak
  • Slovenian
  • Spanish
  • Swedish
  • Turkish

Minimum supported configuration

The following list describes the minimum supported configurations for the MDAC 2.7 SP1 Refresh (2.71.9040.2):
  • Microsoft Windows 98 with the Year 2000 Update 2 and Internet Explorer 4.01 Service Pack 2 (SP2) or later
  • Microsoft Windows 98 Second Edition
  • Microsoft Windows Millennium (Me)
  • Microsoft Windows NT 4.0 Service Pack 5 (SP5) or later and Internet Explorer 4.01 SP2 or later
  • Microsoft Windows 2000
No installation support for the stand-alone release is offered for the Windows XP operating system because this version of MDAC ships as part of Windows XP. MDAC service packs for Windows XP must be obtained through operating system service pack releases.

New features

The MDAC 2.7 SP1 Refresh (2.71.9040.2) is not a new feature release.

Frequently asked questions about MDAC 2.7 SP1

Q1: Where can I find specific Microsoft Knowledge Base (KB) articles for MDAC 2.6?

A1: You can search the public Knowledge Base and use the kbmdac270SP1 keyword.

Note You must only search the Microsoft Knowledge Base for specific technical information, not for bug-related issues. Many bug-related articles describe either fixed bugs or known bugs in this version of the product.

To search the Knowledge Base, visit the following Microsoft Web site:
http://support.microsoft.com
Q2: Where can I find more information about how to set up MDAC, including information about dependencies, supported operating systems, and rollback?

A2: For more information about these topics, visit the following Microsoft Web site:
http://support.microsoft.com/kb/842193/en-us
Note This article was authored for MDAC 2.6, but it is still applicable for MDAC 2.7.

Q3: My application requires Microsoft Jet, but Jet is no longer included in MDAC. Where can I obtain Jet?

A3: MDAC versions 2.6 and later do not include Microsoft Jet. For additional information about the issues involving Jet, click the following article number to view the article in the Microsoft Knowledge Base:
271908 INFO: MDAC version 2.6 and later do not contain Jet or Desktop ODBC drivers
Q4: My application requires the Microsoft Visual FoxPro ODBC driver, but this driver is not included in MDAC 2.6. Where can I obtain the Microsoft Visual FoxPro ODBC driver?

A4: The Visual Fox Pro ODBC driver is included in Visual FoxPro, Microsoft Windows 2000, Microsoft Office 2000, and MDAC 2.5. It is not included with MDAC 2.7 or Windows XP.

Known issues with the MDAC 2.7 SP1 Refresh (2.71.9040.2)

This MDAC release has the following known issues.

MDAC

  • You cannot install the MDAC 2.7 SP1 Refresh on Microsoft SQL Server 7.0 clustered servers. Do not install Microsoft Data Access Components (MDAC) 2.6 or later on any SQL Server 7.0 clustered nodes. If you install MDAC 2.6 or later on any node in the cluster, directly or through the installation of another program, a catastrophic failure of the SQL Server Agent or other SQL Server services may occur. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
    820754 MDAC 2.6 or later should not be installed on SQL Server 7.0 clusters
  • The MDAC resource files that are included in the stand-alone release are different from the MDAC resource files that included as part of the Windows XP SP1 release. The resource files in the 2.7 SP1 stand-alone release are versioned 2.70.9001, and the resource files that included with Windows XP SP1 are versioned 2.70.7713.0. There is no functional difference between the different versions. For specific versioning information for this stand-alone release, see the file list table in this article.
  • When you save a large recordset to the Advanced Data Tablegram (ADTG) format by using the Microsoft SQL Server OLE DB Provider (SQLOLEDB) and by setting the CursorLocation property to adUseServer, some data may be lost when the recordset is reopened from the file. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
    317913 BUG: Data Loss When You Use the Save Method with adPersistADTG and adUseServer

Setup

  • If you are running Microsoft Windows 98 or Microsoft Windows Millennium Edition (Me), when you try to roll your MDAC installation back to an earlier version, your computer will be left in a mixed state, and your files will not all be from the same version of MDAC. This is because of a problem with the setup technology that is included with Windows 98 and Windows Me. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
    311720 MDAC rollback may fail on Windows 95, Windows 98, and Windows Millennium Edition
  • File list differences exist 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
    • Dbmsvinn.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
  • 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 the original release of MDAC 2.7 SP1 (2.71.9030.9), you must install the Windows XP SP1 release. If you want to upgrade Windows XP to the MDAC 2.7 SP1 Refresh (2.71.9040.2), you must upgrade Windows XP to Windows XP SP1, and then you must apply SQL Server 2000 SP3a (MSDE 2000 SP3a).

Significant fixes for the MDAC 2.7 SP1 Refresh (2.71.9040.2)

For additional information about the fixes that are included in the MDAC 2.7 Service Pack 1 Refresh release, click the following article number to view the article in the Microsoft Knowledge Base:
820840 List of bugs that are fixed in MDAC 2.7 Service Pack 1 Refresh
For additional information about the fixes that are included in the original MDAC 2.7 Service Pack 1 release, click the following article number to view the article in the Microsoft Knowledge Base:
326848 List of bugs fixed in MDAC 2.7 Service Pack 1

File list for the MDAC 2.7 SP1 Refresh (2.71.9040.2) 32-bit version

Collapse this tableExpand this table
File nameVersion (x86)Description
Cliconfg.dll2000.80.380.0Client configuration utility
Cliconfg.exe2000.80.380.0Client configuration utility
Cliconfg.rll2000.80.380.0Client configuration utility
Dbmsadsn.dll2000.81.9030.0ADSP Net-Library
Dbmsrpcn.dll2000.81.9030.0RPC Net-Library
Dbmsvinn.dll 2000.81.9030.0VINES Net-Library
Dbnetlib.dll 2000.81.9031.3Winsock oriented Net DLL
Dbnmpntw.dll 2000.81.9030.0Named Pipes Net DLL for SQL clients
Ds16gt.dll 3.510.3711.0ODBC 16-bit driver setup generic thunking
Ds32gt.dll 3.520.9030.0ODBC driver setup generic thunking
Expsrv.dll 6.0.0.8540Expression service
Mdac_typ.exe 27.1.9030.9Installation package
Msadce.dll 2.71.9030.0OLE DB cursor engine
Msadcf.dll 2.71.9030.0Remote Data Services data factory
Msadcfr.dll 2.70.9001.0Remote Data Services data factory resources
Msadco.dll 2.71.9030.0Remote Data Services data control
Msadcor.dll 2.70.9001.0Remote Data Services data control resources
Msadcs.dll 2.71.9030.0Remote Data Services ISAPI library
Msadds.dll 2.71.9030.0OLE DB data shape provider
Msaddsr.dll 2.70.9001.0OLE DB data shape provider resources
Msader15.dll 2.70.9001.0ADO resources
Msado15.dll 2.71.9030.0ADO
Msado20.tlb 2.71.9030.0ADO 2.0 type library
Msado21.tlb 2.71.9030.0ADO 2.1 type library
Msado25.tlb 2.71.9030.0ADO 2.5 type library
Msado26.tlb 2.71.9030.0ADO 2.6 type library
Msadomd.dll 2.71.9030.0ADO MD
Msador15.dll 2.71.9030.0ADO
Msadox.dll 2.71.9030.0ADO extensions
Msadrh15.dll 2.71.9030.0ADO rowset helper
Mscpx32r.dll 3.520.9030.0ODBC code page translator resources
Mscpxl32.dll 3.520.9001.0ODBC code page translator
Msdadc.dll 2.71.9030.0OLE DB data conversion stub
Msdaenum.dll 2.71.9030.0OLE DB root enumerator stub
Msdaer.dll 2.71.9030.0OLE DB error collection stub
Msdamg9x.dll 2.71.9030.0Windows 98 migration DLL
Msdaora.dll 2.71.9030.0OLE DB Provider for Oracle
Msdaorar.dll 2.70.9001.0OLE DB Provider for Oracle resources
Msdaosp.dll 2.71.9030.0OLE DB simple provider
Msdaprsr.dll 2.70.9001.0OLE DB persistence services resources
Msdaprst.dll 2.71.9030.0OLE DB persistence services
Msdaps.dll 2.71.9030.0OLE DB interface proxies/stubs
Msdarem.dll 2.71.9030.0OLE DB remote provider
Msdaremr.dll 2.70.9001.0OLE DB remote provider resources
Msdart.dll 2.71.9031.4OLE DB runtime routines
Msdasc.dll 2.71.9030.0OLE DB service components stub
Msdasql.dll 2.71.9030.0OLE DB provider for ODBC drivers
Msdasqlr.dll 2.70.9001.0OLE DB provider for ODBC drivers resources
Msdatl3.dll 2.71.9030.0OLE DB implementation support routines
Msdatt.dll 2.71.9030.0OLE DB temporary table services
Msdaurl.dll 9.1.9030.0OLE DB RootBinder stub
Msdfmap.dll 2.71.9030.0Data factory handler
Msjro.dll 2.71.9030.0Jet and replication objects
Msjtes40.dll 4.0.2927.8Jet expression service
Msorc32r.dll 2.573.9001.0ODBC driver for Oracle resource library
Msorcl32.dll 2.573.9030.0ODBC driver for Oracle
Msvcirt.dll 6.0.8168.0 C++ runtime library
Msvcrt.dll 6.0.8397.0C runtime library
Mswdat10.dll 4.0.3829.2 Jet sort tables
Mswstr10.dll 4.0.3829.2 Jet sort library
Msxactps.dll 2.71.9030.0OLE DB transaction proxies/stubs
Msxml3.dll 8.30.9926.0MSXML3
Msxml3a.dll 8.20.8730.1MSXML3 resource file
Msxml3r.dll 8.20.8730.1MSXML3 resource file
Mtxdm.dll 1999.6.902.0MTS connection pooling - ODBC driver manager
Mtxoci.dll 1999.6.854.0MTS - Oracle OCI
Odbc16gt.dll 3.510.3711.0ODBC 16-bit generic thunking
Odbc32.dll 3.520.9030.0ODBC driver manager
Odbc32gt.dll 3.520.9030.0ODBC driver generic thunking
Odbcad32.exe 3.520.9030.0ODBC administrator
Odbcbcp.dll 2000.81.9031.38SQL Server ODBC driver BCP library
Odbcconf.dll 3.520.9030.0ODBC driver configuration program
Odbcconf.exe 3.520.9030.0ODBC driver configuration program
Odbccp32.cpl 3.520.9001.0ODBC control panel
Odbccp32.dll 3.520.9030.0ODBC installer
Odbccr32.dll 3.520.9030.0ODBC cursor library
Odbccu32.dll 3.520.9030.0ODBC cursor library
Odbcint.dll 3.520.9001.0ODBC resources
Odbctrac.dll 3.520.9030.0ODBC driver manager trace
Oledb32.dll 2.71.9031.4OLE DB core services
Oledb32a.dll 2.70.9001.0OLE DB core services ANSI resources
Oledb32r.dll 2.70.9001.0OLE DB core services resources
Psapi.dll 4.0.1371.1Process status helper
Sqloledb.dll 2000.81.9031.18OLE DB Provider for SQL Server
Sqloledb.rll 2000.81.9001.0OLE DB Provider for SQL Server resource library
Sqlsrv32.dll 2000.81.9031.38SQL Server ODBC Driver
Sqlsrv32.rll 2000.81.9001.0SQL Server ODBC Driver resource library
Sqlunirl.dll 2000.80.728.0SQL Server Unicode resource layer library
Sqlxmlx.dll 2000.81.9030.0XML extensions for SQL Server
Sqlxmlx.rll 2000.80.382.0XML extensions for SQL Server resource library
Vbajet32.dll 6.0.1.8268 Expression service loader

References

For more information, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/data/aa937729.aspx
For more information about product downloads and update downloads, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/data/aa937712.aspx
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
232060 MDAC Setup Troubleshooting Guide

Properties

Article ID: 842262 - Last Review: June 20, 2014 - Revision: 5.0
Keywords: 
kbservice kbdll kbupgrade kbuninstall kbsetup kblocalization kbfunctions kbdownload kbjet kbinfo KB842262

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com