Error message: unable to find the requested .NET framework data provider. It may not be installed.

 

Solution:

 

A. (re)install the following applications: (this part is a copy from autodesk solution)

 

  1. Open your windows control panel.
  2. Click “Programs”
  3. Click “Programs and Features”.
  4. Find and highlight “Microsoft SQL Server Compact 3.5 SP2 ENU”.
  5. Click “Repair”
  6. Find and highlight “Microsoft SQL Server Compact 3.5 SP2 x64 ENU”.
  7. Click “Repair”
  8. Find and highlight "Microsoft .NET Framework"
  9. Click "Uninstall / Change"

B. If it still does not work: change the following: (this is what helped for me!)

 

Go to C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config AND C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

 

in machine.config change the following:

 

instead of <DbProviderFactories/> put:

 

 

x64

<DbProviderFactories><add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/><add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>

--------------------

x32

<DbProviderFactories><add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/><add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>