Sunday, February 19, 2012

Can a Sql CE 2.0 application be a subscriber of a Sql Server 2005 publication ?

We actuallly have en error when we try to synchronize a ppc 2003 device
running an application built with CF 1.0 and Sql Ce 2.0 and a Sql 2005
server.
The errror is this one :
28035
SSCE_M_FAILUREQUERYINGHEADER
Internal error: HTTP header information is either corrupted or missing in
the transport message. It could be a network transmission error or an IIS
problem.
The queried dll is the sqlcesa30.dll which works correctly with Sql Mobile
applications on same hardware...
We also check in the publication properties that the minimum client version
is Sql 2000 and not sql 2005.
Thanks,
Steve
Steve,
Yes, a SQL CE 2.0 application can be a subscriber of a SQL Server 2005
publication.
It will need to go through ssceSA20.dll instead of sqlcesa30.dll. You will
need to install SQL CE 2.0 Server Tools.
The dev team has put together a detailed page with steps and upgrade paths
for connectivity tools setup:
Connectivity Tools for SQL Server Mobile, SQL Server 2000, and SQL Server
2005 http://www.microsoft.com/sql/edition...ity-tools.mspx
Thank you!
Syed N. Yousuf
Microsoft Developer Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment