none
The .Net Framework Data Providers require Microsoft Data Access Components(MDAC) RRS feed

  • Question

  • One of my customers obtain this error using my software:
    "The .Net Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later."

    The PC where this error happened has this components:

    Windows XP SP3
    Microsoft .net framework 1.1, 2.0, 3.0, 3.5 installed
    MDAC 2.6 e 2.8 are installed

    Someone could give me some information about this error message and the cause?

    Thanks
    Regards
    Luca

     

    Tuesday, April 19, 2011 12:51 PM

Answers

  • I have resolved repairing MDAC installation with this sequence:

    1. Click Start > Run and type %windir%\inf and click OK.

    2. Right-click mdac.inf and select Install.

    I had to copy the OLE DB, msadc, Ole DB and Binaries folders from another computer and place them in the C:\Program Files\Common Files\System\ folder.

    3. When prompted for each of the following files, try to browse and locate them in the directories specified.

        adcjavas.inc – C:\Windows\servicepackfiles\i386
        handler.reg – C:\Program Files\Common Files\System\msadc
        MDACRdMe.htm – C:\Program Files\Common Files\System\Ado.  I had to rename MDACReadme.htm to MDACRdMe.htm first.
        oledbjvs.inc – C:\Program Files\Common Files\System\Ole DB
        mssoap1.dll – C:\Program Files\Common Files\MSSoap\Binaries
        mssoapr.dll – C:\Program Files\Common Files\MSSoap\Binaries

    After all these steps, MDAC was working again.

    Regards

    Luca

     

    • Marked as answer by FG_luke Thursday, April 21, 2011 3:44 PM
    Thursday, April 21, 2011 3:44 PM
  • Hello Andrew.

    Thanks for your answer.

    My application uses .NET Framework 2.0 SP2.

    My application is installed with an installer made with InstallShield.
    This Installer installs some prerequisite components like ".Net 2.0 Framework SP2", "Microsoft Data Access Components 2.8 (English)", "Microsoft Data Access 2.7 (English)", "Microsoft Jet Database Engine 4.0 (English)", "OLE DB 2.1".

    I will say to my customer to use the programs “netfx_setupverifier_new.zip" and “cc_x86.msi”  to verify the status of installation of MDAC and .net framework.
    Consider also that I'm not able to reproduce the error on my test computer with a fresh installation of Windows XP SP3.
    RegaIn these computer my application is correctly installed and works fine.rds.

    Gianluca

    These are the files create  by the utilities on user computer:

    .net setup verifier:

    ======================================================================
    [04/21/11,08:47:52] Beginning of new SetupVerifier activity logging session
    [04/21/11,08:47:52] Activity log file location: C:\DOCUME~1\user\IMPOST~1\Temp\setupverifier_main_04-21-11_08.47.52.txt
    [04/21/11,08:47:52] Error log file location: C:\DOCUME~1\user\IMPOST~1\Temp\setupverifier_errors_04-21-11_08.47.52.txt
    [04/21/11,08:47:52] Build created on January 17, 2011
    [04/21/11,08:47:53] Detected operating system: Windows XP (x86)
    [04/21/11,08:47:53] Install state for .NET Framework 1.0: not installed.
    [04/21/11,08:47:53] Install state for .NET Framework 1.1: not installed.
    [04/21/11,08:47:53] Install state for .NET Framework 2.0: installed with service pack 2.
    [04/21/11,08:47:53] Install state for .NET Framework 3.0: installed with service pack 2.
    [04/21/11,08:47:53] Install state for .NET Framework 3.5: installed with service pack 1.
    [04/21/11,08:47:53] Install state for .NET Framework 4 Client: installed with no service packs.
    [04/21/11,08:47:53] Install state for .NET Framework 4 Full: installed with no service packs.
    [04/21/11,08:47:53] Not adding product '.NET Framework 1.0' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 1.1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 1.1 SP1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 2.0' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 2.0 SP1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 3.0' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 3.0 SP1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 3.5' because it is not currently installed

     


    • Marked as answer by FG_luke Thursday, April 21, 2011 3:44 PM
    Wednesday, April 20, 2011 8:32 AM

All replies

  • Hi Luca,

     

    Thanks for your post.

     

    Would you please let me know the .NET Framework version that your application runs on? Also, if possible, would you please provide the source code that might cause this error?

     

    This behavior occurs if MDAC version 2.6 or later is not installed on your computer. The Microsoft .NET Framework SDK and the .NET Framework redistributable package do not include the MDAC installation. All .NET applications that use data-access functionality require MDAC 2.6 or later (MDAC 2.7 is recommended). For more information, please see: http://support.microsoft.com/kb/315467

     

    You can let your customer to download and install Microsoft Data Access Components (MDAC) 2.8 SP1 the by the link below:
    http://www.microsoft.com/downloads/en/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e

     

    Additionally, you can suggest your customer to verify the installation status of the .NET Framework with this tool.

     

    If you have any concerns, please feel free to let me know.

     

    Best Regards,


    Andrew Wu [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, April 20, 2011 5:23 AM
    Moderator
  • Hello Andrew.

    Thanks for your answer.

    My application uses .NET Framework 2.0 SP2.

    My application is installed with an installer made with InstallShield.
    This Installer installs some prerequisite components like ".Net 2.0 Framework SP2", "Microsoft Data Access Components 2.8 (English)", "Microsoft Data Access 2.7 (English)", "Microsoft Jet Database Engine 4.0 (English)", "OLE DB 2.1".

    I will say to my customer to use the programs “netfx_setupverifier_new.zip" and “cc_x86.msi”  to verify the status of installation of MDAC and .net framework.
    Consider also that I'm not able to reproduce the error on my test computer with a fresh installation of Windows XP SP3.
    RegaIn these computer my application is correctly installed and works fine.rds.

    Gianluca

    These are the files create  by the utilities on user computer:

    .net setup verifier:

    ======================================================================
    [04/21/11,08:47:52] Beginning of new SetupVerifier activity logging session
    [04/21/11,08:47:52] Activity log file location: C:\DOCUME~1\user\IMPOST~1\Temp\setupverifier_main_04-21-11_08.47.52.txt
    [04/21/11,08:47:52] Error log file location: C:\DOCUME~1\user\IMPOST~1\Temp\setupverifier_errors_04-21-11_08.47.52.txt
    [04/21/11,08:47:52] Build created on January 17, 2011
    [04/21/11,08:47:53] Detected operating system: Windows XP (x86)
    [04/21/11,08:47:53] Install state for .NET Framework 1.0: not installed.
    [04/21/11,08:47:53] Install state for .NET Framework 1.1: not installed.
    [04/21/11,08:47:53] Install state for .NET Framework 2.0: installed with service pack 2.
    [04/21/11,08:47:53] Install state for .NET Framework 3.0: installed with service pack 2.
    [04/21/11,08:47:53] Install state for .NET Framework 3.5: installed with service pack 1.
    [04/21/11,08:47:53] Install state for .NET Framework 4 Client: installed with no service packs.
    [04/21/11,08:47:53] Install state for .NET Framework 4 Full: installed with no service packs.
    [04/21/11,08:47:53] Not adding product '.NET Framework 1.0' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 1.1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 1.1 SP1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 2.0' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 2.0 SP1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 3.0' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 3.0 SP1' because it is not currently installed
    [04/21/11,08:47:53] Not adding product '.NET Framework 3.5' because it is not currently installed

     


    • Marked as answer by FG_luke Thursday, April 21, 2011 3:44 PM
    Wednesday, April 20, 2011 8:32 AM
  • I have resolved repairing MDAC installation with this sequence:

    1. Click Start > Run and type %windir%\inf and click OK.

    2. Right-click mdac.inf and select Install.

    I had to copy the OLE DB, msadc, Ole DB and Binaries folders from another computer and place them in the C:\Program Files\Common Files\System\ folder.

    3. When prompted for each of the following files, try to browse and locate them in the directories specified.

        adcjavas.inc – C:\Windows\servicepackfiles\i386
        handler.reg – C:\Program Files\Common Files\System\msadc
        MDACRdMe.htm – C:\Program Files\Common Files\System\Ado.  I had to rename MDACReadme.htm to MDACRdMe.htm first.
        oledbjvs.inc – C:\Program Files\Common Files\System\Ole DB
        mssoap1.dll – C:\Program Files\Common Files\MSSoap\Binaries
        mssoapr.dll – C:\Program Files\Common Files\MSSoap\Binaries

    After all these steps, MDAC was working again.

    Regards

    Luca

     

    • Marked as answer by FG_luke Thursday, April 21, 2011 3:44 PM
    Thursday, April 21, 2011 3:44 PM
  • Thank you for your post.

    I had the same problem and your solution fixed it - the reason for mine was:

    1. We set up a 2008 server and installed .Net etc.
    2. Some time later changed Program Files location from drive C: to D:
    3. We had to copy "Common Files\System" from "C:\Program Files" and "C:\Program Files (x86)" to D:... to get MDAC working.

    Rob

    Friday, May 4, 2012 9:08 AM
  • I imagine this solved it for you, and that this is an old thread.  But I found this because I was having this issue too with a program I had.  Turns out that it would throw this error constantly on one website and that the solution was to look in the Application Pool and set Load User Profile to TRUE.  Once I did that, it no longer complained about this.

    Anyway... hope it helps someone else.  Maybe try that LOAD USER PROFILE option before installing components from another system..... it doesn't hurt and is reversible.  :)

    Sunday, January 5, 2020 6:30 PM