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

[Steve B.]

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

 

[Syed N. Yousuf [MS]]

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/editions/sqlmobile/connectivity-tools.mspx

Thank you!
Syed N. Yousuf
Microsoft Developer Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Steve B.]

That works... but there is an error in the document.
In the page, that fact we have to install the SqlCE 2.0 agent on the server.
Only the Sql Mobile version is mentionned (line 7, having both Sql CE 2.0
and Sql Mobile subscribers).

Thanks,
Steve

 

[Syed N. Yousuf [MS]]

I am glad the problem is resolved. Please send more details on the doc
error and I will submit it to the team which updates the page.

Thank you!
Syed N. Yousuf
Microsoft Developer Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Steve B.]

Sorry for the late answer...

In some words ...

We are on the case 7 (clients are both SQL CE 2.0 and SQL MOBILE).
The doc tells we have to install the Sql Mobile agent. The Sql CE 2.0 mobile
agent is not mentionned but this is required fothe clients using Sql CE 2.0.


HTH
Steve