Merge Replication and Stored Procedures

[Guest]

Im using CF and SQL CE to create an application that records to SQL 2000
database server. I would like to use merge replication for its support for
SSL & disconnected CE. (Encrypted communication over the wlan is a strict
requirement and it is my understanding that SqlClient in the CF will throw an
error if encrypted communication is attempted.)

I have read 2 books (Rob Tiffany's in particular) that discuss merge
replication and both say that stored procedures (presumably to be run against
the primary SQL 2000 server as opposed to SQL CE) are supported. No further
info is provided. My questions of course are; Has anyone out there done it?
If so, how do you do it? Are return data supported? etc. etc. Additional
info would be greatly appreciated. (I am aware that RDA will permit calls to
stored procedures using SubmitSQL but return data is not supported.)

Bill

 

[Guest]

Hi Bill,

Stored Procedures are not supported on Sql Server CE 2.0. From what I know
it's on the way but you'll have to wait for the next release

If you are online you can directly access SQL Server 2000 (I assume). If you
are offline you can't But you can locally simulate your stored procedures.
If this is what you want, I made a post on this last month than I can repost
if you like.

Cheers,
Sitar.
___