sql server replication: Can SQLCE dsf subcribe to 2 publications from the same server database? -- sql server replication

Can SQLCE dsf subcribe to 2 publications from the same server database?

Dickson
1/31/2006 12:00:00 AM

sql server replication:

Is it possible for a sqlce database to subscribe to 2 publications publish
from the same server database?
I have the sqlce sdf file created from synchronize with the 1st publication
with the "AddOption.CreateDatabase".
Then later i created a 2nd publication from the same database in the server
and I want to subscribe to the new 2nd publication
in the same sqlce sdf file. I get the error "Initializing SQL Server
Reconciler has failed,,,,".

Below is my code :-

---
Dim repl as SqlCeReplication
---
---
If File.Exist("My Documents\Product.sdf") then
repl.Synchronize()
Else
repl.repl.Synchronize(AddOption.CreateDatabase)
End if

Re: Can SQLCE dsf subcribe to 2 publications from the same server database?

Hilary Cotter
1/31/2006 12:00:00 AM

Not in SQL 2000. I believe it is possible in SQL 2005.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]