Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / January 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dickson - 31 Jan 2006 12:11 GMT
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
Hilary Cotter - 31 Jan 2006 13:08 GMT
Not in SQL 2000. I believe it is possible in SQL 2005.

Signature

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

> Is it possible for a sqlce database to subscribe to 2 publications publish
> from the same server database?
[quoted text clipped - 18 lines]
>    repl.repl.Synchronize(AddOption.CreateDatabase)
> End if
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.