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)
- Open your windows control panel.
- Click “Programs”
- Click “Programs and Features”.
- Find and highlight “Microsoft SQL Server Compact 3.5 SP2 ENU”.
- Click “Repair”
- Find and highlight “Microsoft SQL Server Compact 3.5 SP2 x64 ENU”.
- Click “Repair”
- Find and highlight "Microsoft .NET Framework"
- 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>