Microsoft KB Archive/842262

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

Article ID: 842262

Article Last Modified on 3/20/2007

-

APPLIES TO


 * Microsoft Data Access Components 2.7 Service Pack 1

-



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



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

</li> 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.</li> 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

</li></ul>

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

</li> 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</li> Dbmsrpcn.dll</li> Dbmsvinn.dll</li> Ds16gt.dll</li> Mscpx32r.dll</li> Mscpxl32.dll</li> Msdadc.dll</li> Msdaenum.dll</li> Msdaer.dll</li> <li>Msdaora.dll</li> <li>Msdaorar.dll</li> <li>Msdasc.dll</li> <li>Msdatt.dll</li> <li>Msdaurl.dll</li> <li>Msjro.dll</li> <li>Msorc32r.dll</li> <li>Msorcl32.dll</li> <li>Odbc16gt.dll</li></ul> </li> <li>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).</li></ul>

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
<div class="references_section">