locked
SqlExpressProviderSample Error 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 Hengzhe Li Friday, April 22, 2011 7:49 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, November 10, 2008 5:20 AM

All replies

  • You are saying that when you synchronize between Sql Server 2005 and Sql CE with your provider you have no problem.  But you see this error when you synchronize between Sql Server 2005 and SqlExpressProvider.  Right?

     

    Maria del Mar Alvarez Rohena - MSFT

    Saturday, November 15, 2008 1:22 AM
  • Hi Maria,

    Thanks for your reply. Yes you are right. If you want you can give out a try to see the error by downloading the sample sqlexpress provider sample.

    Hope will get some solution from you i have to implement the sync process to my project.

    Im running out of time...!!!!!!!!!!!!!!!!!!!!


    Thanks in advance....
    Sunday, November 23, 2008 5:26 AM