Implementing ASP.NET / SQL Compact 4.0 to Windows Server 2012 problem

Question

0.00/5 (No votes)

See more:

Hi Folks

I asked this question in the server discussion area yesterday but I'm no further forward. Hoping for more success here.

I currently have a .NET 4.0 website successfully running on Windows Server 2008 using a private deployment of SQL Compact 4.0. The database dlls reside in the application's 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. I am using a brand new server installation.

My starting point was to move across all of my website folders, including a test database and SQLCE dlls and test the site - a straight copy of the existing folders and contents.

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

[ArgumentException: The specified store provider cannot be found in the configuration, or is not valid.]
System.Data.EntityClient.EntityConnection.GetFactory(String providerString) +91
System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) +246
System.Data.EntityClient.EntityConnection..ctor(String connectionString) +43
System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) +85

etc

I am still learning .NET and server environment so please be kind. I have researched for answers today also but it seems to raise more questions than answers for me.

This link doesn't seem to indicate I am doing anything wrong with my private deployment of SQL Compact, though clearly something isn't right.

Given my setup and the errors shown is there a best place to look/check first?

Any ideas?

Cheers

Paul ...

Posted 19-Nov-14 1:58am

Paul D D

Add a Solution

Comments

Paul D D 19-Nov-14 8:01am

Forgot to add the link I referred to ... http://technet.microsoft.com/en-us/library/gg213826(v=sql.110).aspx

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AdamASPGeek · Answer 1 · 2014-11-25T19:04:00

Solution 1

Have your hosting provider install SQL CE on the server? If not, please kindly go to http://www.microsoft.com/en-us/download/details.aspx?id=17876[^] and you can install it

Posted 25-Nov-14 19:04pm

AdamASPGeek