Results 1 to 6 of 6

Thread: Error 429 (A2K)

  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error 429 (A2K)

    Well, I have received the dreaded

    Error 429: ActiveX component can't create object.

    MSDN says "The error is typically seen on certain computers but not
    others." and goes on to give a lengthy list of 'troubleshooting tips'.

    In my case the code works on one machine but not another. The one that
    fails originally was missing the reference to the 'Microsoft ADO Ext.2.5
    for DDL and Security'. I put the appropriate dll in the correct
    directory and the References appears to be satisfied.

    I know the line causing the error involves a connection and the only
    difference I have found between the two machines is that the
    connection.version property is 2.1 on the one that fails and 2.5 on the
    one that works.

    Is there some other step required to "register" a reference beyond just
    putting it in the right directory? It *does* appear in the references
    list and I have recompiled.

    TIA
    Donald

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error 429 (A2K)

    I'm not sure of what you're describing. Are you saying that the version of ADO on the two machines is different? Or is the database on the machine that fails not finding the correct reference when it's present?

    If this is a corporate environment, you want to try to make sure that all the machines are up to at least ADO 2.5, which means it needs to be installed on each machine.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 429 (A2K)

    All I can say at this point is that when I break the code on the line that errors, go to the immediate window, and type

    ?cnn.version

    one responds "2.5" and the other "2.1".

    When you say 'ADO 2.5' do you mean MDAC?

    TIA
    Donald

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error 429 (A2K)

    MDAC installs the ADO libraries, nothing more. The 2.1 version came with Office 2000, I believe, but there have been later releases of MDAC so that it's now up to 2.6. There are differences, and 2.5 supports things that don't exist in 2.1. Did you check the references on the 2.1 machine to see if the 2.5 libraries are installed?
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 429 (A2K)

    I downloaded the following at MS:

    MDAC 2.5
    MDAC 2.5 SP 1
    MDAC 2.5SP 2

    Each one is larger than the preceding. Do I need to install them all, or can I just use the last one?

    TIA,
    Donald

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error 429 (A2K)

    Just the last one should do it.
    Charlotte

Posting Permissions

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