Unable to access SQLCE database on Windows Server 2012
-
Hello Folks 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? Thanks Paul ..
-
Hello Folks 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? Thanks Paul ..
-
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.
-
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.
Interestingly I have since (without any changes made) rerun the page and get a different result - strange. The result is: "The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid" What I can't understand is I'm using exactly the same file structure, files and web.config as a working instance of the website so the above error has confused me.
-
Interestingly I have since (without any changes made) rerun the page and get a different result - strange. The result is: "The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid" What I can't understand is I'm using exactly the same file structure, files and web.config as a working instance of the website so the above error has confused me.
-
Hello Folks 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? Thanks Paul ..
Thanks very helpful http://storeprime.com/index.php?dispatch=categories.view&category_id=64[^]