How To Installing MDAC 2.1 from SP5A of SQL Server 6.5

Service Pack 5a for SQL Server 6.5 provides an optional installer for Microsoft Data Access Components 2.1 (MDAC 2.1).

Installing MDAC 2.1 2.10.3513.2 from SQL Server 6.5 SP5a can be accomplished as described below:

1. Run the zip file (Sp5ax86.exe, for example) with "/d" option, which creates an MDAC subfolder with the Mdac_typ.exe file.
2. Run Mdac_typ.exe from its folder to install MDAC 2.1.

NOTE: If you do not use the "/d" option to decompress the SP5A zip file, all files will be placed in a single folder. Running Mdac_typ.exe from that folder may fail to install MDAC in some cases and is not recommended.

Because MDAC install is optional, running SP5A Setup.exe only installs SQL server 6.5 SP5A. SQL Server 6.5 SP5A can be downloaded from the following locations:

• http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=SQL%20Server%206.5%20Post%20Service%20Pack%205a%20Update&DisplayLang=en
• ftp://ftp.microsoft.com/Softlib/MSLFILES/, Sp5ax86.exe, Sp5aalp.exe

The version of Msado15.dll installed by MDAC 2.1 is 2.10.3513.2 or later.

The following information is from the SP5A Readme.txt file.

If you install MDAC 2.1 and do not apply Service Pack 5a setup to SQL Server 6.5, then, in order to use the new SQL ODBC driver or OLEDB provider installed by MDAC 2.1, you will need to run Instcat.sql, which comes with SP5A on SQL Server.

For additional information about this service pack, the installation process, and a list of the included files, please see the following articles in the Microsoft Knowledge Base For more information about MDAC, please see the information at the following link:
(c) Microsoft Corporation 1999, All Rights Reserved. Contributions by Hussein Abuthuraya, Microsoft Corporation.