Monday, March 12, 2012

Micorsoft ActiveX Data object could not be loaded

Hi all,

I wanna use the Microsoft ActiveX Data Object (Multi-dimensional)2.6 Library component
in my VB application, but it returns:
" 'C:\Program Files\Common Files\System\ado\msadomd.dll' could not be loaded "

How to solve this problem?
I am using:
SQL Server 2000 SP2
Analysis Service Sp2

RickYour dll is probably not registered properly. Try to unregister the dll and re-register it. Or download the ado 2.7 version and install it.|||I am running on win2k server, is it safe to use 2.7?
I'm now using MDAC 2.6 SP2 (2.62.7926.1)
thanks~

Rick|||If you feel uncomfortable installing 2.7, I would try unregistering the dll and re-registering. If that does not work, try to reinstall 2.6. One of the sps for sql server may update the dll, so make a note as to which version you are currently using - it may be as simple as an unregistered or corrupted dll.

Good luck.|||Thanks again!
I have use the MDAC Component Checker from the M$ website,
it seems that my version is 2.6 SP2 (2.62.7926.1) and
meets the version in register,

I have unreg and reg the dlls,
but I still got the following components errors:

1. Microsoft ActiveX Data Object (Multi-dimensional)2.6 Library Component
'C:\Program Files\Common Files\System\ado\msadomd.dll'
could not be loaded

2 OLAP Manager Cube Browser
'C:\...\Microsoft Analysis Services\Bin\msmdcb.ocx' could
not be loaded

I'm using SQL2000 Sp2, Analysis Services Sp2, VB 6 SP5
Will it look like a Ananlysis Services problem?

Rick|||Well, your last choices are to try re-install 2.6 and/or installing 2.7. What is the date/time size on these files which are failing ?

No comments:

Post a Comment