HOWTO: 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 can be accomplished as described below:
If you plan to upgrade your server or client computer to any of the components delivered with MDAC 2.1, start the installer, Mdac_typ.exe, in the I386\Mdac or Alpha\Mdac directory and follow the instructions. Before doing that, be sure to review the instructions in the Mdacread.txt file. Even if you do not run the optional MDAC installer, Service Pack 5a Setup runs Instcat.sql, which updates the catalog stored procedures and guarantees compatibility to clients that are on MDAC 2.1.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
Q197176 INF: Readme.txt for SQL Server 6.5 Service Pack 5a
Q137636 INF: Relationship of the ODBC Driver to INSTCAT.SQLFor more information about MDAC, please see the information at the following link: http://www.microsoft.com/data
Additional query words:
Keywords : kbsetup kbDatabase kbMDAC kbSQLServ650sp5
Version : WINDOWS:2.1
Platform : WINDOWS
Issue type : kbhowto
Last Reviewed: March 20, 1999