Automation error when using ADO / MDAC
OK, trying to get a definitive answer to this question ...
I have an application written in VB6 that requires MDAC (2.8 for this installation). MDAC is included in the installer for my application. When the software is uninstalled and reinstalled on the same computer, MDAC seems to be wrong and I get the following error as soon as my application tries to connect to the database:
Runtime error '-2147024769 (8007007f)':
Automation Error The specified procedure was not found.
I have tried reinstalling MDAC, which succeeds but does not fix the problem. I've searched most of the internet and found many people with a similar problem in different environments (VS.NET, JAVA, etc.), Actually everything depends on MDAC but can't find a clear answer. Anyone who has a clean solution will receive my most grateful thanks and thanks.
Pending.
source to share
Have you tried Microsoft's MDAC Component Checker ? It is a tool for diagnosing problems and reconfiguring MDAC installations.
source to share
I have found that removing MDAC 2.8 is nearly impossible. However, running a component check, modifying registry entries, and placing a different version of MSDART fixed the issue.
The MSDART I installed in place is not the one suggested by the Component Checker, but it works. The checker component also has an issue with the MSXML version, but the software seems to work independently, so I'll cover that later. However, my problem is resolved. So very fast. Thanks and praises you Mitch and Stackerk. Fine!
source to share