Cannot connect to sql compact

See more:

SQL

.NETCF

Hello,

I designed a web service project. It is supposed to synchronize sql server and sql compact databases. After the sqlce db is synchronized on the server, it is pulled (downloaded) from wince embedded handheld devices for warehouse operations.

I successfully coded, debugged and tested the web service project on my pc, but when I published it to the test server I got several errors, but especially:

Unable to load DLL 'sqlceme35.dll': The specified module could not be found.

So I decided to deploy the service with private sqlce deployment following the instructions below

http://erikej.blogspot.com.tr/2012/05/private-deployment-of-sql-server.html[^]

But I failed.. :( So my other choice was to upgrade it to sqlce 4.0. I thought myself fairly successful until I realized that sqlce 4.0 is meant for ASP.NET applications not for wince embedded devices :(.

For that reason I uninstalled sqlce 4.0 installation (unwisely :( ). But after that, I got another terrible error:

sql compact Unspecified error (SQL Server Compact ADO.NET Data Provider)

This try-and-got-bigger-and-bigger-error situation made me very frustrated. If anyone can help me please help me!

Cem Karaer