“SQL Server Compact is not intended for ASP.NET development.”
Right…So you have this cool thing that allows you to have a SQL database in a hosting that only provides MySQL databases and such but you can’t use it. You got to be kidding me.
But, if really, really, really want it, there you go:
AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
Just put before the call to the database is made (Global.asax, etc.).
Bigsby Spot 
Hey there! I could have sworn I’ve been to this site before but after browsing through some of the post I realized it’s new to me.
Anyhow, I’m definitely glad I found it and I’ll be bookmarking and checking back often!