Microsoft KB Archive/842280

= Release manifest for MDAC 2.7 Refresh (2.70.9001.0) =

Article ID: 842280

Article Last Modified on 3/20/2007

-

APPLIES TO


 * Microsoft Data Access Components 2.7

-





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

For information about downloading MDAC releases, visit the following MSDN Web site:

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

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 &quot;kbmdac270&quot; keyword. To search the Microsoft Knowledge Base, visit the following Microsoft Web site:

http://support.microsoft.com/?scid=fh;%5Bln%5D;kbhowto

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 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 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.</li> A new DSN protocol might be used for older DSNs or vice versa.</li></ul>

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

289573 PRB: Configuring DSNs with SQL Server Net-libraries

</li> 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 PRB: SQL Server 2000 installation or local connections fail with &quot;SSL Security error :ConnectionOpen (SECDoClientHandshake)&quot; error message

</li> 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 FIX: Cannot browse cubes or process mining model after you Install Analysis Services 2000 RTM

</li> 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 PRB: Configuring DSNs with SQL Server Net-Libraries

</li> 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.</li> 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 PRB: Error when you implement nested transaction with OLE DB Provider for SQL Provider

</li> 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 INFO: Installation of MSXML parser affects Run mode

</li> 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.</li> 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 PRB: MDAC Rollback may fail on Windows 95, Windows 98, and Windows Millennium Edition

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

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.  <li>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 INFO: Explanation of the MDAC 2.7 Refresh release

</li></ul>

File list for MDAC 2.7 RTM (2.70. 9001.0) 32-bit
Additional query words: MDAC manifest

Keywords: kbinfo KB842280

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.