locked
Changes from client to server sync not working RRS feed

  • Question

  • Hi,

     

    We are using SQL Express provider for ado.net sync to develop an application to sync between SQL Server 2005(server) and SQL Express 2005(client).

     

    The scenario is as below:

     

    1. We synchronize data from server to client (which loads a fresh set of data successfuly on client)

    2. Now we change some rows on the client DB (updates) on the rows which were synchronized from the server DB.

    3. Now when we try to synchronize the changes from the client Db to Server back, it gives us a primary key violation error as below:

     

    Error Message:

     

    Conflict detected while applying changes to the server.

     

    Table: Orders.

    Conflict Type: ClientInsertServerInsert.

    Error: Violation of PRIMARY KEY Constraint ‘PK_orders_7c848OAE’. Cannot insert duplicate key in key in object ‘dbo.orders’.

    The statement has been terminated.

    Order_id:381.

    The server row will not be updated.

     

     

    Could anyone please tell us what could be wrong in this sql express adotpion, the same works when we use a SQL Ce on the client.

     

    The original sample which we took from the link below also has this same issue:

     

    http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=1200

     

    Pls any help would be greatly appreciated

    • Moved by Max Wang_1983 Thursday, April 21, 2011 6:04 PM forum consolidation (From:SyncFx - Technical Discussion [ReadOnly])
    Thursday, November 6, 2008 9:52 AM

Answers

All replies

  • Could you please refer to posting, http://forums.microsoft.com/sync/ShowPost.aspx?PostID=4092167&SiteID=75 and see if it may help?

     

    Thanks.

    Friday, November 7, 2008 1:36 AM
    Answerer
  •  

    Hi,

     

    Thanks for the same,

     

    I went through the notes in that link and tried out, but get stuck with the same error message.

     

    Do you have a copy of the sql express sample which doesn't have the same problem, probably the correct working version.

     

    Probably we could use that. Thanks a lot for all the help in advance.

     

    you could post me the link and I would pick it up from there.

     

    Regards

    Friday, November 7, 2008 11:24 AM