Microsoft Data Access Component Issues and Articles

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!

• Microsoft has made an outstanding commitment to maintain current information about how any of their products address Y2K issues. This commitment includes relevant information about the Microsoft Data Access Components and Y2K, and you can review that information at the  Microsoft Y2K Information Center. Click on the link and a new page will open for the Information Center. Scroll to the product drop-down list and select a component from the Data Access section. A list will then be returned with all versions of the component that currently have Y2K information available.

• Added January 29: Consolidated MDAC Y2K information for the stack has been added to the Data Access section of the Microsoft Y2K Information Center pages in addition to information on the separate components. Choose Microsoft Data Access Components from the dropdown list to view the consolidated Y2K information. You will find that site has the most current information available from Microsoft and is updated frequently.

• Added July 26: The MDAC Y2K document has been updated to include information on 2.1 SP2 (2.1.2.4202.3).

• Attention Windows 95 Users: You must install DCOM for Windows 95 before installing 2.1x or 2.5x. For more information please read the article MDAC 2.0 Requires DCOM95 to Install Under Windows 95. DCOM for Windows 95 is available for download directly from Microsoft and can be found at: Download DCOM for Windows 95.

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.

• To download, click the link above, where you will follow this process:

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:

• Identify the current MDAC installation on your computer.
• Create a series of reports about the files identified for the current MDAC installation.
• Remove the current MDAC installation after first listing .dll conflicts and identifying programs that reference a given .dll.

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.

• To download, click the link above, and follow this process:

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

• You must accept the license agreement
• Read the MDAC 2.1.1.3711.11 (GA) Release Manifest
• Download MDAC 2.1.1.3711.11 (GA) for U.S. English
• Download MDAC 2.1.1.3711.11 (GA) for Brazilian Portuguese*,Chinese (Simplified)*, Chinese (Traditional)*, Czech*, Danish*, Dutch*, English*, Finnish*, French*, German*, Greek, Hungarian*, Italian*, Japanese*, Korean*, Norwegian*, Polish*, Russian*, Slovak, Slovenian, Spanish*, Swedish*, and Turkish. (* Available for both x86 and Alpha.) 

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