Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Unanswered: 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

    Rick

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Your 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.

  3. #3
    Join Date
    Jul 2002
    Posts
    8
    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

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  5. #5
    Join Date
    Jul 2002
    Posts
    8

    Post

    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

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •