After installing MP-5, on starting application receive error:
Engine :
Monitor Enterprise
Number : -2147024769
Description : Automation error
The specified procedure could not be found.
Location : Monitor/EntLocal/Main
Source : mpDataAccess
The information in the article refers to:
Monitor-Pro MP-5
Applies to:
| Product: | MP-5 |
| Reported Version: | MP5.0.1 |
| Applies to: | All MP-5 versions |
| Area of effect | Install, MDAC |
Synopsis
On certain early versions of Windows XP and XP SP1, choosing the default option to upgrade MDAC in the MP-5 setup results in an error on running MP-5 as follows:
How do you resolve this issue?
Solution
This is because MDAC has not upgraded correctly. MP-5 (and many other applications) rely on MDAC (Microsoft Data Access Components) to connect to databases. With this non-operational, MP-5 cannot start.
This issue has not been replicated by Monitor-Pro and the fixes below are based on assumptions…
Option 1 (based on information from the Microsoft Web Site)
a) Shut down all Windows NT services and Windows applications that are using MDAC. For MP-5 users this will probably be:
|
Internet Explorer |
|
Microsoft Office (All Office Applications) |
|
Outlook and Outlook Express |
|
SQL Server |
Note: Stop SQL
Server by right clicking the green triangle icon
in
systray (stop then exit to be sure)
Other possibilities are:
|
Certificate Server |
|
Exchange Server |
|
Internet Information Server |
|
SNA Server |
|
SMS Server |
|
Visual Studio (All Development Products) |
b) Reapply mdac 2.8 & restart SQL Server (or reboot will do this automatically. You can run MDAC_2.8 from the MP-5 setup CD (in the admin folder) or the latest one can be downloaded from the Microsoft Web Site: http://www.microsoft.com/downloads/details.aspx?FamilyID=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&DisplayLang=en
Microsoft knowledge base article on the above:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232060
Option 2 (replacement of 3 specific dll’s):
Replace three key system files thought to be affected.
These are (and correct version information):
Odbc32.dll 244k v3.525 4/8/2004 C:\WINDOWS\system32
Oledb32.dll 476k v2.81 21/08/2004 C:\Program Files\Common Files\System\Ole DB
Msado15.dll 524k v2.8.1 04/08/2004 C:\Program Files\Common Files\System\ado
Pure replacement will not work as there is a backup copy in C:\WINDOWS\system32\dllcache. Upon replacement, its backup is retrieved from the cache & you’re back to where you started!
Therefore you need to first overwrite the cache dll’s. There is a useful application to do this on the EHSData Web site: www.ehsdata.com/downloads/MDACinstallfailurefix_attempt.exe
This will replace the cache files – but gives a choice to copy the new dll’s to a location of your choice. Once this has been run, copying the dll’s to their locations as above should fix the error.
If this does not resolve your issue, please contact support