SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Regarding Merge Replication on Pocket Pc device
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mandar
Starting Member

India
2 Posts

Posted - 06/21/2005 :  06:27:21  Show Profile  Reply with Quote


Respected Sir/Mam,

I'm developing a application on Pocket Pc emulator by using Merge replication to synchronize the database.

Database synchronization works totally fine in both the directions i.e frm Pocket PC -> Local Database & vice versa.

But when i try to insert a new record, i get the error as follows...

"A duplicate value cannot be inserted into Unique index..."

when i execute the SAME query in Ms SQL it works fine....But the same query gives error in Compact Environment.

When i searched on Net, I got one solution But it also did not work w.r.t my application.

it suggested...Delete the index column and then get the snapshot of the database...

But my index are generated with respect to PRIMARY Key column and thats why Ms SQL denies to delete indexes.

Thus, I hereby request You to suggest me something which i can implement.

Regards,

Mandar C Jambotkar,

Agrofoyer Solutions Pvt. Ltd.,
India
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000