Hey,

do you get the exception while connecting or wile requesting a query?

I had the same problem with a query like "SELECT TOP 1 ...". SQL Server COmpact doesn't understand that....

Hey,

I've got a similar problem. But in my case, it isn't working with more than one parameter:

http://social.msdn.microsoft.com/Forums/de-DE/sqlce/thread/28a24ce8-6b54-4e8a-af77-58fa91b497e3

Hey,

try this: http://www.johnnycantcode.com/page/SQL-Server-to-SQL-Server-Compact-Edition-Database-Copy.aspx

Maybe you have to add some functionality for your case. I did some extensions to the code and everything works fine!