none
An Unexpected error occurred in the .Net Framework Data Provider for Microsoft SQL Server Compact 4.0

    Question

  • I am getting this error message when I attempt to connect my application to a database.  

    "An Unexpected error occurred in the .Net Framework Data Provider for Microsoft SQL Server Compact 4.0 "  

    Everything else appears to be operating just fine.  I have attempted to repair the installation as well as resetting all settings in Tools -> Import and Export Settings

    I am running VS 2010 Premium 

    Any assistance would be appreciated.


    Steve

    Friday, June 15, 2012 5:32 AM

All replies

  • Hi Steve,

    Welcome to the MSDN forum.

    We'll need more information to reproduce this issue.

    In my mind this issue will indicates error settings first.

    But we can do something to reproduce this issue and narrow down it.

    Please try the following workarounds:

    1. Show me your OS version,

    2. Show me Visual Studio Service package level, if you haven't installed SP1, please install it.

    3. Use this too to verify .NET Framework http://blogs.msdn.com/b/astebner/archive/2008/10/13/8999004.aspx

        Then show us the results here. First 15 line and last 15 line will show you helpful information.

    4. On this link partners provided many helpful solutions. But please note that edit registry is not recommended and if you really want to have a try, you need to backup it first. http://social.msdn.microsoft.com/Forums/pl-PL/vstsstart/thread/b6f7fc36-5a34-4166-9e75-7ac39993182b

    5. Related topic have be discussed here http://connect.microsoft.com/VisualStudio/feedback/details/666901/error-after-de-installing-vs2010-sp1

        You can try to see if installing SQL Server Compact 4.0 onto your machine would fix your issue.

    Please show me your updates.

    Thanks,


    Barry Wang [MSFT]
    MSDN Community Support | Feedback to us


    Monday, June 18, 2012 7:51 AM
  • I am Running this on Windows & (64 bit)

    I have Visual Studio Premium With Service Pack 1 Installed.   Version 10.0.30319.1 RTMRel  Microsoft .Net Framework 4.0.30319 RTMRel

    Here is the output from the Verification tool...

    ======================================================================
    [06/18/12,13:24:54] Beginning of new SetupVerifier activity logging session
    [06/18/12,13:24:54] Activity log file location: C:\Users\smaas\AppData\Local\Temp\setupverifier_main_06-18-12_13.24.54.txt
    [06/18/12,13:24:54] Error log file location: C:\Users\smaas\AppData\Local\Temp\setupverifier_errors_06-18-12_13.24.54.txt
    [06/18/12,13:24:54] Build created on December 29, 2011
    [06/18/12,13:24:54] Detected operating system: Windows 7 (x64)
    [06/18/12,13:24:54] Install state for .NET Framework 1.0: not installed.
    [06/18/12,13:24:54] Install state for .NET Framework 1.1: not installed.
    [06/18/12,13:24:54] Install state for .NET Framework 2.0: installed with service pack 2.
    [06/18/12,13:24:54] Install state for .NET Framework 3.0: installed with service pack 2.
    [06/18/12,13:24:54] Install state for .NET Framework 3.5: installed with service pack 1.
    [06/18/12,13:24:54] Install state for .NET Framework 4 Client: installed with no service packs.
    [06/18/12,13:24:54] Install state for .NET Framework 4 Full: installed with no service packs.
    [06/18/12,13:24:54] Not adding product '.NET Framework 1.0' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 1.1' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 1.1 SP1' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 2.0' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 2.0 SP1' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 3.0' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 3.0 SP1' because it is not currently installed
    [06/18/12,13:24:54] Not adding product '.NET Framework 3.5' because it is not currently installed
    [06/18/12,13:25:13] Starting verification for product .NET Framework 4 Full

    --- Last several lines.

    [06/18/12,13:25:19] Key: HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
    Value: Version
    Actual Data: REGISTRY VALUE FOUND
    [06/18/12,13:25:19] Section [Registry - .NET Framework 4 Full (Common)] - stop parsing entries
    [06/18/12,13:25:19] Not running action 'Registry - .NET Framework 4 Full (32-bit)' for product '.NET Framework 4 Full' because the OS condition does not match
    [06/18/12,13:25:19] Section [Registry - .NET Framework 4 Full (64-bit)] - start parsing entries
    [06/18/12,13:25:19] Section [Registry - .NET Framework 4 Full (64-bit)] - stop parsing entries
    [06/18/12,13:25:19] Section [Registry - .NET Framework 4 Full (Wow6432Node)] - start parsing entries
    [06/18/12,13:25:19] Key: HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
    Value: Install
    Expected Data: 1
    Actual Data: 1
    [06/18/12,13:25:19] Key: HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
    Value: InstallPath
    Actual Data: REGISTRY VALUE FOUND
    [06/18/12,13:25:19] Key: HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
    Value: Servicing
    Actual Data: REGISTRY VALUE FOUND
    [06/18/12,13:25:19] Key: HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
    Value: TargetVersion
    Expected Data: 4.0.0
    Actual Data: 4.0.0
    [06/18/12,13:25:19] Key: HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
    Value: Version
    Actual Data: REGISTRY VALUE FOUND
    [06/18/12,13:25:19] Section [Registry - .NET Framework 4 Full (Wow6432Node)] - stop parsing entries
    [06/18/12,13:25:19] Processing custom action 'Custom Action - .NET Framework 4.0 test application'
    [06/18/12,13:25:19] ExecutablePath = 'Netfx40TestApplication.exe'
    [06/18/12,13:25:19] FriendlyName = '.NET Framework 4 test application'
    [06/18/12,13:25:19] TimeoutSeconds = '300'
    [06/18/12,13:25:19] WaitOnExit = 'true'
    [06/18/12,13:25:19] Silent = 'true'
    [06/18/12,13:25:19] Launching process 'Netfx40TestApplication.exe' now
    [06/18/12,13:25:19] Process successfully launched. Waiting 300 seconds for it to complete.
    [06/18/12,13:25:19] Process 'Netfx40TestApplication.exe' exited with return code 0
    [06/18/12,13:25:19] Verification succeeded for product .NET Framework 4 Full

    I have uninstalled and re-installed Microsoft Compact 4.0 on my machine.


    Steve

    Monday, June 18, 2012 8:35 PM
  • Hi Steve,

    From your description, .NET installs well on your OS. Also, you haven't mention that you meet problem when install VS2010. So I first I should ask if you have any error when installing Visual Studio and .NET Framework. If not, the issue should be a application setting error.

    Sorry for the wrong directory. I suddenly relized this issue should based on your programming language.

    Could you please show me your project type and language so that I can redirect you to the right forum.

    Thanks, 


    Barry Wang [MSFT]
    MSDN Community Support | Feedback to us


    Monday, June 25, 2012 5:34 AM