RUNTIME ERROR 2147024769 (8007007F)

Posted on 2006-04-07
Last Modified: 2012-06-21
I have an application developed in Visual Basic 6, SP6.  It is deployed and running on Windows 2000 Pro, XP, and Windows 2003 Server.
Using the latest and greatest Windows 2003 Server (w/SP1), the applicaiton no longer functions.  We get a "Run-time error -2147024769 (8007007f): Automation error.  The specified procedure could not be found".  We experienced this on a new Dell server, and also on a generic server we set up using Microsoft's 180 day trial version of w2k3.  This error does not occur on any other systems.
The exact line of code causing the error is the ADODB connection open (in this case to a MS Access file): "Provider=Microsoft.Jet.OLEDB.4.0;User ID=;Password='';Data Source=Database1.mdb;Mode=Share Deny None"
Microsoft's component checker reports no errors.  The MDAC version installed is 2.8SP1.  

Any ideas?  Thanks in advance for any help.....
Question by:cwomer
    LVL 9

    Accepted Solution

    Sounds like the same problem this person had:

    Must be a problem with MDAC.  Read these knowledgebase articles on how to correct it:

    Best of luck!

    Author Comment

    Turns out that the msado15.dll  ( ver 2.82.1830.0)  supplied with server 2003 sp1  is not compatable with win 2000/XP. In fact, if we install this version on XP we  get the same automation runtime error we were getting with server 2003. The msado15.dll we are supplying in our install kit is ver 2.71.9030.0 and this causes the automation runtime error on server 2003.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    This is about my first experience with programming Arduino.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now