Microsoft Data Access Component
"MDAC"
Issues and Articles

There are presently three releases of MDAC that are available: Two releases for MDAC 2.1 and the Release To Manufacturing (RTM) release of MDAC 2.5. You can also review and download the release manifests for MDAC. A Release Manifest is designed to provide you with details as to version numbers, release dates and how a particular release was made available. You may also want to review installation information regarding MDAC.

MDAC 2.5 RTM (2.50.4403.12) is now available for download from this site. An RTM release was previously called a (GA) release. This Web release is the same version of MDAC that is installed by Windows® 2000. Read the MDAC 2.5 release details.

MDAC 2.1 SP2 is still available for download from this site. This Web release is the second Generally Available (GA) version of MDAC 2.1 and is referred to as MDAC 2.1.2.4202.3 (GA).

MDAC 2.1.2.4202.3 (GA) addresses a number of issues from previous releases. Read the MDAC 2.1 release details.

Besides MDAC, you can also download the Component Checker tool from Microsoft from this page. According to Microsoft, an updated version of Component Checker that includes a snapshot for Windows 2000 will be made available soon.

If you are trying to locate either MDAC 1.5 or 2.0 to download, please note that they are no longer available. You should use the most current version of the Microsoft Data Access Components as noted in this document. While MDAC 1.5 is included with Personal Web Server version 4.0, we recommend that you deploy 2.1 or later.

Allaire Cold Fusion Issues:

Problems with OLE DB datasources on Windows 2000 (Article # 14709)


You May Want To Read This Before You Download Anything!


2.5 SDK

Microsoft Data Access Components 2.5 SDK Available on the Microsoft Platform SDK

The Microsoft Data Access Components (MDAC) 2.5 SDK can be found on the Microsoft Platform SDK. 

Microsoft Data Access Components (MDAC) 2.5 SDK

To download the latest Microsoft Data Access Components SDK from the Microsoft Platform SDK, click the link above, and then follow these procedures:

  1. You will see a page that describes where the components reside in the Microsoft Platform SDK.
  2. Choose to run the Microsoft Platform SDK Setup in the second paragraph.
  3. This will start the installation of the Microsoft Platform SDK on your system. Follow the prompts to install and then you can select the MDAC information you want.
  4. Note: You can also choose to download the SDK and install the components later.

2.5 Released

The latest release of the Microsoft Data Access Components, 2.5 RTM (2.50.4403.12), is now Available!

This release is first release of version 2.5 RTM of the Microsoft Data Access Components. This download installs the same version of the MDAC components that are installed by Windows 2000. There is no MDAC 2.5 version for Alpha machines. For Alpha based installations, there is only MDAC 2.1.2.4202.3 (GA).

There have been a number of questions about MDAC releases, release-specific issues, and upgrade considerations, and with that, the Microsoft MDAC team has developed manifests for each release that discuss release-specific issues and details.

Read the MDAC Manifest Introduction for an explanation of release issues. You may also want to specifically review the Microsoft MDAC 2.5 RTM (2.50.4403.12) Release Manifest and the Microsoft MDAC Installation FAQ. All releases of MDAC and the Data Access SDK will include a version-specific release manifest. The current manifest is for the release of MDAC 2.5 RTM (2.50.4403.12).

Download MDAC 2.5 RTM (2.50.4403.12)
The languages available for download for MDAC 2.5 RTM (2.50.4403.12) x86 are U.S. English, Brazilian, Chinese (Traditional and Simplified), Czech, Danish, Dutch, Finnish, French, German, Greek, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Russian, Spanish, Swedish and Turkish.

  1. Accept the license agreement.
  2. Choose the download you want from the list.

Component Checker

The Component Checker tool was designed by Microsoft to help you determine the installed version information as well as diagnose installation issues with the Microsoft Data Access Components (MDAC) on your computer. The Component Checker runs on Microsoft Windows 95, Windows 98, Windows 98SE, Windows NT 4.0, and Windows 2000. Only 32-bit and 64-bit platforms are supported. The Component Checker has been updated to include MDAC 2.5 data.

MDAC is installed with numerous Microsoft products and also can be redistributed using the redistribution program (mdac_typ.exe) accessible through the links elsewhere on this page as well as on the Microsoft MDAC site.

Component Checker is a customizable tool that will do the following:


2.1 Releases

Microsoft Data Access Components 2.1.2.4202.3 (GA) also available.

This release is the second (GA) version of Microsoft Data Access Components (MDAC) 2.1 and is referred to as MDAC 2.1.2.4202.3 (GA). The MDAC 2.1.2.4202.3 (GA) release is also referred to as MDAC 2.1 SP2 in various Microsoft Knowledge Base Articles.

Please keep in mind that the original MDAC 2.1 was shipped with SQL Sever 7.0, and a small incremented version was then shipped with IE 5.0 (this was MDAC 2.1 without drivers or providers). Next MDAC 2.1.1.3711.11 (GA) was released. Some articles refer to this as MDAC 2.1 SP1. The most current release is 2.1.2.4202.3 and is a service pack to the MDAC 2.1 stack. There are no new features in this release. The version number on the msado15.dll should match the above version number.

As with MDAC 2.5, there have been a number of questions about the various MDAC releases, as well as release-specific issues and upgrade considerations. You can learn more about MDAC 2.5 from its manifest by reading the Manifest Introduction. You also may want to read specifically the MDAC 2.1.2.4202.3 (GA) Release Manifest and the MDAC Installation FAQ. All releases of MDAC and the Data Access SDK will include a version-specific release manifest. The current manifest is for this release of MDAC 2.1.2.4202.3 (GA).

Download MDAC 2.1.2.4202.3 (GA)
The languages now available for download for MDAC 2.1.2.4202.3 (GA) x86 and Alpha include U.S. English, French, German, Italian, Spanish, Japanese, Simplified Chinese, Traditional Chinese, Korean, Swedish, Norwegian, Finnish, Danish, and Brazilian Portuguese.

  1. Accept the license agreement.
  2. Choose the download you want from the list.

MDAC 2.1.1.3711.11 (GA) the early release is still available.

The languages available include U.S. English, Brazilian Portuguese, Czech, Danish, Dutch, Finnish, French, German, Greek, Hungarian, Iberian Portuguese, Italian, Japanese, Korean, Norwegian, Polish, Russian, Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Traditional Chinese, and Turkish

 

Important Issues


Access ODBC Keyset Cursor Becomes Corrupt After a Delete (2/22/2000).

An issue arose regarding Microsoft Data Access Components versions 2.1 and 2.1 SP1 whereby the Access ODBC Keyset Cursor becomes corrupt after a deletion occurs.

You can learn more about this issue by reviewing the Microsoft Knowledge Article #Q230131

Important! All Windows 95, Windows 98 and Windows 98SE users should review the above Microsoft Knowledge Base Article!

Microsoft has released a hot fix that addresses this issue. You should review the readme file included in the  self-extracting zip file before implementing this fix.

Download the HOTFIX - JetODBC.exe (210KB)


A Data Access Update is available for x86 and Alpha based systems.

If you have downloaded or installed the MDAC 2.1 from Microsoft SQL Service Service Pack 5 or SQL Server 7.0, there is a Data Access Software Development Kit (DA SDK) 2.1 Update available with updated headers, libraries, and documentation for building applications with MDAC 2.1. This update should be used with the tools and samples provided in Data Access SDK version 2.0, and the MDAC component files must be installed separately.

Data Access SDK 2.1 Update Available for x86 and Alpha
If you obtained the Microsoft Data Access Components (MDAC) 2.1 from Microsoft SQL Server 6.5 SP5 or SQL Server 7.0, the The  The DA SDK 2.1  MDAC 2.1 is now available from this site (see above headline).

To upgrade your current Data Access SDK 2.0 installation with the 2.1 docs, headers, and libraries, download SDKUpd_i.exe (for x86 machines) or SDKUpd_a.exe (for Alpha machines) and install over your current files. The default installation directory is C:\Msdasdk, which can be customized.

The above material is being provided to you in support of particular products, including those provided by Microsoft and others. In those cases where the information we have provided is protected by copyrights belonging to others, we hereby acknowledge those copyrights. In all other instances, the information that we have developed is our own and is protected by our copyrights.

Updated August 12, 2000

Copyright ©2000 DEW Associates Corporation. All rights reserved.
Your privacy will be respected at all times.
Year 2000 Readiness Disclosure.