At CodeProject we spend an awful lot of time playing with room heaters, or as others like to call them, "servers". Over the years we've seen it all, some of it smoking, most of it usually working just nicely until something happens.
What that something is can be hard to find so we've created a quiet place for those battle scarred and frustrated to get a little help.
I currently have a .NET 4.0 website successfully running on Windows Server 2008. It utilises SQL Compact 4.0 which resides in the App_Data folder. The database dlls reside in the bin folder.
I am moving to a new web host company and I want to test this on Windows 2012, ultimately with a view to moving to .NET 4.5 and, later, SQL Server.
My starting point was to move across all of my website folders, including a test database and SQLCE dlls and test the site.
Unfortunately I get the following error message when loading the home page for the first time. "Unable to find the requested .Net Framework Data Provider. It may not be installed. "
The first part of the trace states:
[ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.]
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +1480919
System.Data.EntityClient.EntityConnection.GetFactory(String providerString) +26
I am still learning .NET and server environment so please be kind. I have researched for answers this morning but it seems to raise more questions than answers for me.
Given my setup and the errors shown is there a best place to look/check first?
That suggests that you do not have SQLCE installed on the new server, even though you have copied the DLLs. Some products are required to have the installation process run in order to set up links and registration information.