locked
ADODB.Connection Automation Error RRS feed

  • Question

  • Hi,

    I am running the retail (RTM) version of Windows 7 ultimate.
    Ever since I installed the operating system, programs that use ADO no longer work.

    Whether in Windows Scripting Host, MS Office VBA, or VB6, whenever I try to create an ADODB.Connection object, I get the following error:

    Database Error
    ---------------------------
    There was an error opening the database:

    Error -2147024703 - Automation error
    %1 is not a valid Win32 application.
    ---------------------------

    Note that the error occurs even before any connection is opened (i.e. before Connection.Open(connstring) is called) So this is NOT connection-string or DNS related. The error occurs when the connection object is created.

    e.g.

    set objConn = new ADODB.Connection
    or
    set objConn = CreateObject(ADODB.Connection)

    Note also that WDAC (6.0) IS installed as well as MDAC (2.5 - 2.8). I can add references to these libraries, but no matter which one I use, the results are the same. I always get that error right at the creation of the conneciton object.

    I would just re-install WDAC, but it seems there is no way to do this on Windows 7.

    I'd appreciate any help or suggestions anyone could offer.
    Thanks!
    Friday, January 29, 2010 9:01 PM

All replies