Microsoft Data Access Component MDAC Release Manifests

MDAC Release Manifests

In response to customer feedback, new releases of the Microsoft Data Access Components (MDAC) and the MDAC Software Developer’s Kit (SDK) will include a release manifest. Eventually, manifests for former releases will also be generated. Their purpose is to relate important details specific to each release.

Each release manifest includes the following information:

• Version information, including version number, function, ship vehicle, new features, localization information, and other important notes.
• File lists for the release as a whole and for any subsets of the release.
• Known issues and significant fixes, including incompatibilities fixed in each version.

For information about installing, uninstalling, upgrading, and downgrading MDAC releases, see “Installing MDAC Q&A.”

The following table lists each release of MDAC that is slated to have or already has its own manifest. The releases that now have manifests available are linked to them below.

MDAC releases have been given a new naming convention as well. The revised names better and more accurately reference each release.

Revised name

Ship vehicle

Release date

MDAC 2.5 RTM

MDAC 2.5 RTM (2.50.4403.12)

Microsoft Windows 2000

http://www.microsoft.com/data/download.htm

February 2000

MDAC 2.1 SP2

MDAC 2.1.2.4202.3 (GA)

Microsoft Universal Data Access Web site

http://www.microsoft.com/data/download.htm

July 1999

MDAC 2.1 SP1a

MDAC 2.1.1.3711.11 (GA)

Microsoft Universal Data Access Web site

http://www.microsoft.com/data/download.htm

April 1999

MDAC 2.1 Internet Explorer 5 SP1

(a subset of MDAC 2.1.1.3711.11(GA))

Microsoft Internet Explorer 5.0

March 1999

MDAC 2.1 SDK updater

MDAC 2.1 SDK updater

Microsoft Universal Data Access Web site

http://www.microsoft.com/data/download.htm

January 1999

MDAC 2.1 RTM

MDAC 2.10.3513.2 (SQL7)

Microsoft SQL Server 7.0

November 1999

 

Installing MDAC Q&A

Q: What components ship with MDAC?

The MDAC typical redistribution installation contains the core components (ADO, OLE DB, and ODBC) and

additional OLE DB providers and ODBC drivers for various data stores. Additional information about these components can be found in the Microsoft Data Access SDK documentation.

Q: What is the best procedure for installing or upgrading MDAC?

As with all product upgrades, you should test to verify that existing applications work as expected with the upgrade before applying it to production systems. Adopting a proactive installation and upgrade strategy is the most effective way you can avoid rollbacks. If you first upgrade a test system with a configuration identical to the production system, you can identify potential issues and avoid the hurdles associated with a rollback. To ensure a successful upgrade, identify issues with an MDAC upgrade before committing it to production systems, and alert Microsoft Product Support Services (PSS) to any problems as early as possible in your development and deployment cycle.

As with any system upgrade, if you are unable to implement it on a test system, you should have a comprehensive backup or disk image of your production system as well as a complete recovery plan.

Q: Many applications ship with MDAC included. How can I tell if the version of MDAC on my system has been updated by an application installation?

You can check the version numbers on specific .dll files associated with MDAC to determine the version installed on your system. The following table summarizes what file versions correspond to which MDAC versions.

MDAC version	Msdadc.dll	Oledb32.dll	Notes
MDAC 1.5c	1.50.3506.0	N/A
MDAC 2.0	2.0.3002.4	2.0.1706.0
MDAC 2.0 SP1	2.0.3002.23	2.0.1706.0
MDAC 2.0 SP2	2.0.3002.23	2.0.1706.0	Superset: SP1
MDAC 2.1.0.3513.2 (SQL)	2.10.3513.0	2.10.3513.0
MDAC 2.1.1.3711.6 (Internet Explorer 5)	2.10.3711.2	2.10.3711.2
MDAC 2.1.1.3711.11 (GA)	2.10.3711.2	2.10.3711.9
MDAC 2.5 RTM (2.50.4403.12)	2.50.4403.0	2.50.4403.8

Note these version numbers and compare them after an application installation to determine whether MDAC was upgraded. We also encourage you to view the MDAC Release Manifest for more information about MDAC versioning.

Q: Can I uninstall MDAC?

The Microsoft Data Access Components are system components, and installing MDAC should be considered similar to a system upgrade. You cannot remove MDAC without replacing operating system files that were upgraded by the MDAC installer. Many applications, including Microsoft Internet Explorer, Visual Studio, SQL Server, and Office require MDAC for data binding and other application functions. Removing MDAC will negatively impact or break these applications. However, under certain circumstances, Microsoft Product Support Services can assist you in solving installation and behavior problems. For more information, see “What should I do if an MDAC upgrade breaks my application?”

Q: What should I do if an MDAC upgrade breaks my application?

If you encounter issues with your application after an MDAC upgrade, consider the following:

1. Issues with components other than MDAC can be misinterpreted as being specific to MDAC. Before reporting an issue, we strongly recommend that you isolate the issue as specific to MDAC. Microsoft Product Support Services can assist in determining whether an issue is specific to MDAC.
2. If you have isolated the issue as specific to MDAC, we encourage you to contact PSS and let us work with you to develop a fix for the problem that will enable you to maintain your current installation. Many applications include updated versions of MDAC. These applications can be negatively impacted or broken if an earlier version of MDAC replaces the version bundled with the product. Rolling MDAC 2.1 back to MDAC 2.0, for example, will break Microsoft SQL Server 7 and also eliminate the Year 2000 remediation addressed in the version 2.1 release. If you discover an issue with an MDAC release, alerting us will enable the MDAC team to address the issue and continue to make MDAC a better product.
3. PSS can help you identify the source of the issue, recommend a quick-fix engineering (QFE) solution, or promote the issue as a potential QFE candidate (if applicable). Finally, under certain circumstances, PSS can assist you in removing and reinstalling MDAC after exhausting other means of resolution.

Q: How can I roll back to a previous version of MDAC if an upgrade breaks my applications?

If you need to roll back to a previous version of MDAC, you have two primary options, which generally correspond to the type of system involved (test or production):

• On production systems, use your backup or disk image (taken immediately before the upgrade) to return to the configuration before the upgrade was installed.
• On test systems, the simplest solution is often to reformat the hard drive and reinstall all applications.

In both situations, however, we urge you to work with Microsoft Product Support Services to develop a solution that installs and maintains the upgrade version of MDAC. PSS might already have a quick-fix engineering solution that addresses your particular issue.

Under certain circumstances, PSS can assist you in removing and reinstalling MDAC after exhausting other means of resolution.

Q: Which applications will be affected if I roll back MDAC version X to MDAC version X-n?

We cannot test all possible rollback scenarios. Different applications rely on specific MDAC components, and interdependencies are highly specific to individual system configurations.