Hey everyone,
I recently ran into a problem with the YA application on a client PC. The problem was with MDAC (Microsoft Data Access Components). YA requires that MDAC be Rel 2.7 or later. In this particular instance, the customer had upgraded the MDAC from the Microsoft website to Rel 2.8. But, when YA was started, there were errors. The error was that YA thought that the MDAC was Rel 2.0. We check the registries, used the MDAC checker tool from Microsoft, nothing showed us that the MDAC was at Rel 2.0.
The customer then dug a bit deeper and searched Google, gotta love Google!! The steps below is what he found and it cleared up our problem. Just thought I would share so you all have an extra tool in your kit!
Reinstall MDAC components
On Windows XP, if updating MDAC fails, reinstall the most recent version of the MDAC components from the Windows .cab files. To do this, follow these steps.
Note If you have the Windows XP CD, do not finish step 1. 1. Search for the Adcjavas.inc file, and then make a note of the path. The Adcjavas.inc file is typically in the i386 folder.
2. Locate the C:\Windows\Inf folder.
3. Right-click the Mdac.inf file, and then click Install.
4. When you are prompted to insert the Windows XP CD, insert it. If you do not have the Windows XP CD, change the path to match the path for Adcjavas.inc (in the i386 folder) that you noted in step 1, and then click OK.
**************************************
My Biggest problem is that I almost always believe what I tell myself.
I recently ran into a problem with the YA application on a client PC. The problem was with MDAC (Microsoft Data Access Components). YA requires that MDAC be Rel 2.7 or later. In this particular instance, the customer had upgraded the MDAC from the Microsoft website to Rel 2.8. But, when YA was started, there were errors. The error was that YA thought that the MDAC was Rel 2.0. We check the registries, used the MDAC checker tool from Microsoft, nothing showed us that the MDAC was at Rel 2.0.
The customer then dug a bit deeper and searched Google, gotta love Google!! The steps below is what he found and it cleared up our problem. Just thought I would share so you all have an extra tool in your kit!
Reinstall MDAC components
On Windows XP, if updating MDAC fails, reinstall the most recent version of the MDAC components from the Windows .cab files. To do this, follow these steps.
Note If you have the Windows XP CD, do not finish step 1. 1. Search for the Adcjavas.inc file, and then make a note of the path. The Adcjavas.inc file is typically in the i386 folder.
2. Locate the C:\Windows\Inf folder.
3. Right-click the Mdac.inf file, and then click Install.
4. When you are prompted to insert the Windows XP CD, insert it. If you do not have the Windows XP CD, change the path to match the path for Adcjavas.inc (in the i386 folder) that you noted in step 1, and then click OK.
**************************************
My Biggest problem is that I almost always believe what I tell myself.