Not a pretty looking error. Maybe bit scary…..Although I personally have not seen many customer’s reports of this message, I had it on my own machine and by coincidence I had a question about the same exact issue coming around the same time I was struggling to figure out what went wrong and how to dig myself out of this hole. That, along with somehow misleading error message made me decide to share my findings and save some of you from the headache I had. I don’t know for sure what the cause of this misbehavior was but my doubts are that originates from my multiple install and uninstall of Subassembly Creator and the requirements for it. .NET Framework 4.0 and SQL Compact Edition. So when I tried to open an existing Survey Database for edit I was greeted by this message:
Message: Unable to find the Requested .NET Framework Data Provider. It may not be installed.
Hint: To check if the issue is with .NET Framework, see if you can verify your installation by running .NET Framework Setup Verification Tool User's Guide available from here: http://blogs.msdn.com/astebner/pages/8999004.aspx
As I said, even though the message indicates the issue with .NET Framework the resolution in fact came from repairing of SQL Server. Good thing is that your original install DVD or your deployment have the backup of this component. Find SSCERuntime-ENU-x86.msi file and run it. Choose Repair option and finish installation.
The SSCERuntime-ENU-x86.msi could be found in your deployment as well as on your DVDs:
- Deployment: … AdminImage\x64\en-US\Support\SQL_Server_CE_3.5\x86\
- 64-bit DVD: D:\X64\EN-US\SUPPORT\SQL_SERVER_CE_3.5\X86\
- 32-bit DVD: D:\X86\EN-US\SUPPORT\SQL_SERVER_CE_3.5
Finally try to create new Survey Database or open an existing one and see if that helped.
Good to know: If you have the Microsoft SQL Server Compact 3.5 Service Pack 2 installed, you may not be able to run the repair as the installer will find that the later version of SQL SE is present. So you would need to repair or reinstall that one.
The repair can be run from Control Panel>Programs and Features or from C:\Program Files\SQL Server Compact 3.5 SP2. Complete download available from here.
Note from Microsoft: Microsoft SQL Server Compact 3.5 Service Pack 2 has separate Windows Installer (MSI) files for 32-bit (x86) and 64-bit (x64 or AMD64) Computers. It is mandatory to install both the 32-bit and the 64-bit version of SQL Server Compact MSI files on a 64-bit Computer. Installing only the 32-bit version of the SQL Server Compact 3.5 SP2 MSI file on a 64-bit computer will lead to failure of the existing SQL Server Compact 3.5 applications on the Computer. If you are developing an application that uses SQL Server Compact 3.5 SP2 than you should package both the 32-bit and the 64-bit version of the SQL Server Compact MSI files and install both of them on a 64-bit Computer along with your application.
Installing SQL Server Compact 3.5 SP2 on a 64-bit computer (x64 or AMD64):
1. Install the 32-bit version of SQL Server Compact 3.5 SP2 by running the SSCERuntime-ENU-x86.msi
2. Than install the 64-bit version of SQL Server Compact 3.5 SP2 by running the SSCERuntime-ENU-x64.msi
For 32-bit version you only need 32-bit version of MSI file.