All, I have a big compatibility issue between VS, Windows CE, SQL Server 2005 and SQL Server CE, which is sending me around in circles.
My application is written in VS2003, and due to size and complexity, I cannot yet move it onto VS2005 or 2008. Currently, it uses RDA to sync with SQL Server 2000 (SP3) through SQL Server CE 2.0. However, the database on the main server is changing to SQL Server 2005. I have tried to RDA from CE 2.0 to SQL Server 2005 (sqlcesa30.dll) and it fails with error (28035) – Header information is corrupt. But other web sites say that sqlcesa30.dll is for SQL Server mobile, not CE and I should continue to use sqlcesa20.dll on the server side, which is a Sql 2000 version (which I cant see working). If I use the (sqlcesa30.dll) version, will by handheld CE 2.0 talk to this, because I cant get CE 3.0 or 3.1 loaded on my handheld device without upgrading to VS2005. Does anybody have any clarification on what I need both client (handheld) side and server side in order to get my VS2003 Sql CE 2.0 program RDA’ing with SQL Server 2005 on the server side. Why does Microsoft have to have so many versions, and keep changing them all the time? John
