1

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.

Tony
  • 68
  • 2
  • 6

2 Answers2

2

Have you tried the MDAC Component Checker from Microsoft? It is a tool for diagnosing problems and reconfiguring MDAC installations.

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541
  • Thanks Mitch Following your suggestion have just run the MDAC Component Checker. There are some mismatched files and mismatched registry entries. I shall try changing all the registry entries first and see what happens. I guess I may be able to download the correct file versions from somewhere? – Tony Nov 12 '08 at 12:44
  • I would completely remove MDAC and then re-install. – Mitch Wheat Nov 12 '08 at 12:47
1

I have found removing MDAC 2.8 to be all but impossible. However, having run the component checker, changing the registry entries and putting a different version of MSDART the problem has been fixed.

The MSDART I have put in place is not the one suggested by the component checker, but it works. The component checker also has a problem with the version of MSXML, but the software seems to work regardless, so I'll look into this at a later date. However my problem is solved. So very quickly. Thanks and praises to you Mitch, and Stackoverflow. Great!

Tony
  • 68
  • 2
  • 6