Re: msadox.dll error -2147024770

From: Val Mazur (group51a_at_hotmail.com)
Date: 08/20/04

  • Next message: Jan Hyde: "Re: ADO Connection -- Find out if record was updated or not" 
    Date: Thu, 19 Aug 2004 22:42:31 -0400

    Hi,

    Sorry, but I probably marked your post as I read it and did not see until
    last reply. I have checked MDAC 2.8 installation and it suppose to update
    ADOX as well. What is the version of msadox15.dll file on your PC after MDAC
    2.8 installation?
    About 2 business days support: it will be from Microsoft, if you send them
    question directly. I am here just another guy from outside of Microsoft, who
    is trying to help all of you for free when I have some spare time. If you do
    not see reply in a couple of days, then best way is to post same topic again
    with the REPOST prefix in a subject. Like in my case I occasionally marked
    post and I did not see it. In a case of repost someone or me could pick it
    up 

    -- 
Val Mazur
Microsoft MVP
"jch" <jch@discussions.microsoft.com> wrote in message 
news:7A2FD56C-3EEE-46C7-AE1C-54C054053B2F@microsoft.com...
>I was expecting to receive response to my previous reply within 2 business
> days.  The component checker on the problem machine did produce items with
> Mismatch Fields, which I didn't interpret as an "error".  The mismatches 
> are
> on the ADOX components, which have values in the CurVer registry keys that
> indicate version 2.5, where version 2.8 is expected.  Running the
> MDAC_TYP.exe installation for MDAC 2.8 does not update these values.  So I
> need to know how to force the installation of ADOX version 2.8 components.
>
> "Val Mazur" wrote:
>
>> Even if files identical it does not mean MDAC is not corrupted. This DLL
>> could call another file. Did Component Checker show any errors or not
>>
>> -- 
>> Val Mazur
>> Microsoft MVP
>>
>>
>> "jch" <jch@discussions.microsoft.com> wrote in message
>> news:167FB82E-E02F-4ED0-ABB1-FB89C8AF3EFE@microsoft.com...
>> >I ran component checker on a machine that works, and the one with the
>> >Automation error.  The results file from both machines is identical. 
>> >Any
>> >other suggestions?
>> >
>> > "Val Mazur" wrote:
>> >
>> >> Hi,
>> >>
>> >> Looks like MDAC is corrupted on this PC. Try to run Component Checker
>> >> utility, which ships with MDAC to see if installation of MDAC good or 
>> >> not
>> >>
>> >> -- 
>> >> Val Mazur
>> >> Microsoft MVP
>> >>
>> >>
>> >> "jch" <jch@discussions.microsoft.com> wrote in message
>> >> news:286BC26D-6015-496D-ADEA-8E80F6A899A1@microsoft.com...
>> >> >I am having trouble with the Microsoft ADO Ext. 2.7 for DDL and 
>> >> >Security
>> >> >library (msadox.dll).  I have included this reference in my project, 
>> >> >and
>> >> >I
>> >> >have a procedure that requires the Catalog object:
>> >> >
>> >> > 100 Dim objCatalog as ADOX.Catalog
>> >> > 110 Set objCatalog = New ADOX.Catalog
>> >> >
>> >> > Line 110 causes the error -2147024770 "Automation Error.  The 
>> >> > specified
>> >> > module could not be found."
>> >> >
>> >> > The error is only encountered on an end-user's machine (WinXP Pro),
>> >> > after
>> >> > deployment.  The deployment package includes MDAC 2.7, and we have
>> >> > since
>> >> > had the user download and install MDAC 2.8.
>> >> >
>> >> > Since this application works on several other test and production
>> >> > machines, the cause of the problem is difficult to pinpoint.
>> >> > Reinstalling
>> >> > my application does not work; "Repairing" my application's 
>> >> > installation
>> >> > also does not work.  Perhaps there is some dependent file that is
>> >> > corrupted, but I don't know how to test this theory, especially 
>> >> > since a
>> >> > full reinstall does not resolve the problem.  I have sent a test app
>> >> > that
>> >> > does nothing but create an ADOX.Catalog object, and it fails.
>> >> >
>> >> > Any suggestions are welcome.
>> >>
>> >>
>> >>
>>
>>
>>
  • Next message: Jan Hyde: "Re: ADO Connection -- Find out if record was updated or not"

    Relevant Pages

    • Re: ODBC(Open Database Connectivity)errors
      ... When you initially start the Component Checker, ... That being the case you need to update MDAC and possibly JET ... cc_pkg.exe is the installer ...
      (microsoft.public.windowsxp.general)
    • Re: missing DTS connections
      ... I ran the component checker and it reports that MDAC is OK! ... >>All of us have missing connections in the DTS designer. ... >>installation all the connections were available however after applying ...
      (microsoft.public.sqlserver.connect)
    • RE: SQLDMO install client machine - Specified module could not be
      ... Let's take another step to ensure that the installation of MDAC has no ... INFO: Component Checker: Diagnose Problems and Reconfigure MDAC ... If there are not mismatched files, I'd like to run Regmon and Filemon while ...
      (microsoft.public.sqlserver.setup)
    • Re: missing DTS connections
      ... You can check your MDAC installation using component ... Component Checker: Diagnose problems and reconfigure MDAC ... >All of us have missing connections in the DTS designer. ...
      (microsoft.public.sqlserver.connect)
    • Re: Security Update
      ... Maybe U bouth should download Microsoft Data Access Components Checker Tool ... The Component Checker tool is designed to help you determine installed ... Access Components (MDAC). ... Identifies the current MDAC installation on a computer. ...
      (microsoft.public.security)