OK, struggling to get a definitive answer to this one…
I have an application written in VB6 which requires MDAC (2.8 for this installation). MDAC is included in the installer for my application. When the software is removed and re-installed on the same machine MDAC seems to go awry and I receive the following error as soon as my application tries to connect to the database:
Run-time error '-2147024769 (8007007f)':
Automation error
The specified procedure could not be found.
I have tried reinstalling MDAC which completes successfully, but does not fix the problem. I have searched over much of the Internet and found many people with a similar problem in different environments (VS.NET, JAVA etc), in fact anything that relies on MDAC, but cannot find a clear answer. Anyone who has a clean solution would receive my most merrily given thanks and appreciation.
Yours in bated anticipation.
Best Answer
Have you tried the MDAC Component Checker from Microsoft? It is a tool for diagnosing problems and reconfiguring MDAC installations.