SQL CE Deploy - AppHarbor - Unable to load SQL Server Compact native components

Question

I have fully complied with the following posts:

http://support.appharbor.com/discussions/problems/544-error-with-reference-to-systemdatasqlserverceentity-dll

Using SQL Server CE 4 on a remote host with MVC 3

and I still get the following error:

Unable to load native SQL Server Compact components that match the ADO.NET provider version 8482. Install the correct version of SQL Server Compact. See Article KB 974247 for more details.

What I've done:

Fresh file → New ASP.NET MVC application 3. Through NuGet, EFCodeFirst.SqLServerCompact v0.8.8482.1 was added, which added the necessary packages.

Locally, everything works fine. I create / clean / restore and complete the whole solution through Git and click on AppHarbor. All pages that do not affect SQL CE work as expected. When I try to load a page that speaks with SQL CE, I see a related exception:

Below are my packages:

Below is the catalog of my cart:

Answer 1

I also could not get this to work, I spent a lot of time trying. I just switched to the correct SQL Server supported by AppHarbor (since using SqlCompact in the App_Data folder is dangerous for various reasons).

Answer 2

CE SQL Server can be run on AppHarbor, although we do not recommend using it for the reasons Danny Tuppeny mentions. This support file contains working code.

Answer 3

I had the same problem with Asp.net. Here's how I solved it:

The problem was with the resolution. Current Application Pool Identifier . IWAM_plesk (by default) did not have access to SQL Server Compact 4.0 folders:

C: \ Program Files \ Microsoft SQL Server Compact Edition \ v4.0

C: \ Program Files (x86) \ Microsoft SQL Server Compact Edition \ v4.0

I just granted read and execute permissions and a list of the contents of the folder, and now it works like a charm.