WinXP VB6 run-time error 3706

Posted on 2007-07-24
Last Modified: 2013-12-25
I am installing a VB6SP6 app on WinXP Pro connected to SQL Server Express 2005. I installed on (5) machines without a problem. On the next pc, I get the error: Run-time error 3706 Provider cannot be found. I installed and tested the SQL Native Client the same on all machines and received 'Test Completed Successfully' so am thinking the database connection is working but not the ADO database connection. Have searched Google & EE for this error message but mostly get dead-end links. I need help fixing this error.
Question by:sahinman
    LVL 18

    Accepted Solution

    Provider can not be found points to the fact that either MDAC that you are using in your application is not installed on the machine or the present install is corrupt. So install MDAC again and try.

    Author Comment

    I found and ran MS Component Checker, it identified MDAC 2.8 SP1, I downloaded the latest MDAC installer file but it gave the following error: MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows. How do I 'install MDAC again'?
    LVL 18

    Expert Comment

    Check this link:

    I guess you will have to first remove Windows SP2 on that machine.
    LVL 18

    Expert Comment

    Is it working now?

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now