locked
Anchor Problem RRS feed

  • Question

  • I'm using SqlExpressClientSyncProvider to synchronize two sql servers.
    Problem is always @sync_last_received_anchor & @sync_new_received_anchor are always the same and equal to 0x00000000000084D0 , so incremental commands ( insert , update , delete ) always return empty result set and my synchronization fails.
    It's my select new anchor command :


    // select new anchor command
    SqlCommand anchorCmd = new SqlCommand();
    anchorCmd.CommandType = CommandType.Text;anchorCmd.CommandText = "Select @" + SyncSession.SyncNewReceivedAnchor + " = @@DBTS";
    anchorCmd.Parameters.Add("@" + SyncSession.SyncNewReceivedAnchor, SqlDbType.Timestamp).Direction = ParameterDirection.Output;

    • Moved by Tina_Tian Friday, April 22, 2011 8:03 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Wednesday, October 15, 2008 8:44 PM

Answers

  •  

    Can you double check your SelectNewAnchorCommand on the server provider? Also can you double check the anchor values in your anchor tables to see what values is being stored in them for each server.
    • Marked as answer by phpcs Thursday, April 23, 2009 7:36 PM
    Friday, October 17, 2008 4:18 AM
    Moderator