We've been trying to get UploadOnly working using Synccomm on a SQL Server CE Device DB to a SQL Server 2008 Service with Change Tracking. The first set of data from the device goes up to the database, but the UploadChangesFailed is always equal to
the number of rows sent up. Then, all edits after that fail to upload.
SyncStatistics statistics = agent.Synchronize();
if (statistics.UploadChangesFailed > 0)
On the server side, we handle the following, and the event handler is called twice for each record, first with ClientInsertServerInsert, then with ErrorsOccurred, and the rows fail to update in the Server database. We even tried ApplyAction.RetyrWithForceWrite
private void RemoteProviderFr8Scanner_ApplyChangeFailed(object sender, ApplyChangeFailedEventArgs e)
if (e == null || e.Conflict == null) return;
e.Action = ApplyAction.Continue;
If I try to set the mode to bidirectional, I get an error trying to access the anchor.