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

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:

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