SQL CE 4 Data Provider may not be installed.

[jezz]

Hi,

Just wondering whether there is any solution to this.

I am using SQL CE 4 and have managed to get it working by specifying a connection string and executing text commands through that connection. However, by looking at the examples of how to use SQL CE 4 effectively (i.e. circumventing the lack of stored procedure and view support) it seems as though the route to take involves ADO.NET Entity Data Models. I have got this working on my development machine but when I copy to the discountasp.net servers I get the following error:

Unable to find the requested .Net Framework Data Provider. It may not be installed.

I have done some searching and found one post in which it was mentioned that CE was not supported (although it was acknowledged that it can be used through deployment of a WebMatrix project) as it is for mobile devices. This does not, however, seem to be the case with CE 4 as Microsoft have been going out of their way to make SQL CE 4 deployable on hosting scenarios such as discountasp.net but without this data provider it becomes too clumsy to use.

If anyone has a solution/opinion I'd be very grateful

Thanks

jezz :-)

[joelkarr]

I got the same thing.

It looks like discountasp.net is blocking it.

I saw on another thread that they say they only support it for the web matrix projects. I do see why they would let it work there but not on a web application though.

[bruce]

we are not blocking SQL CE4..

you should be able use SQL CE as long as you upload all the SQL CE 4 dll to the server.

See http://blogs.msdn.com/b/webdevtools/archive/2011/01/06/how-to-bin-deploy-sql-compact-edition-4-0-and-razor-web-projects.aspx