Hi Abdul:I recently encountered similar problems and did a ton of research. It's onanother computer and I have to go out now, but will post the information laterif desired.Basically, MDAC 2.5 and updates come with Win2K, MDAC 2.6 and updates come withSQL Server, while MDAC 2.7 and updates come with WinXP.
From what I read, it'snot nice to fool with mother nature on that score, because it's hard to undo.Since MDAC 2.5 and Win2K, the data access components are now more of anintegral part of the operating system (OS) than other redistributablecomponents. Microsoft has a utility called the ComponentChecker you candownload to check your version in case different DLL versions get mixed up; butas I recall it can't fix MDAC installations on the later OS's. Hi again Abdul:First of all, sorry this took a few days to post. I was having ISPtrouble with the account that's registered in Ittoolbox, which delayedmy getting around to this.How are you going with that MDAC problem?I prepared the memo and literature review below when I encounterednumerous problems with a VB 6 Package & Deployment Wizard setup packagelast month. A number of the problems related to my thinking it might bea good idea to upgrade my ADO reference to 2.6 and distribute MDAC 2.6. Without knowing what I was doing.I had to have my development machine completely rebuilt by the time Ihad finished tinkering trying to solve the problem.
OverviewMicrosoft Windows XP with Service Pack 2 contains MDAC (Microsoft Data Access Components) version 2.81, which is currently not available for download at the Microsoft Web site as a standalone installation. If you try to install MDAC v2.8, which is the latest available standalone download of MDAC, you will receive a message that you already have a newer version of MDAC installed. Therefore, under Windows XP SP2, you must manually repair MDAC 2.81 as outlined below. How to Repair MDAC 2.81 under Windows XP with SP2In Windows Explorer, open the C:WindowsInf folder. Right click the Mdac.inf file and then click Install. When prompted to insert the Windows XP SP2 CD, use one of the following methods: If you have a Windows XP SP2 CD. Insert the Windows XP SP2 CD.
Repair Mdac Installation Windows 7 Professional
If the “Welcome Microsoft Windows XP” message appears, click Exit. Click Browse. In the File name box, enter the drive letter which corresponds to the CD and the i386 folder. For example, “F:i386”.
Click Open.If you do not have a Windows XP SP2 CD. In the File name box type%systemroot%windowsserviceoackfilesi386 and click Open.
When prompted for adcjavas,inc, point to C:windowsservicepackfilesi386. When prompted for the file handler.reg, point to C:Program FilesCommon FilesSystemmsdac. When prompted for MDACRdMe.htm, point to C:Program FilesCommon FilesSystemAdo.