Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

cannot insert rows into Pulled table (RDA)

Posted on 2011-03-09
2
Medium Priority
?
376 Views
Last Modified: 2013-12-27
hello,

I've setup a RDA (Remote Data Access) connection between a PocketPC(Windows CE 5.0) and a SQL Server 2008 Express. Everything works fine (the Pull and the Push), but I can't insert rows into the tables in the SQL Mobile 3.5 database. Pulled tables have Identity rows and Primary keys on the Identity row. I can update and delete rows, but when I try to insert, it give the following error: "A duplicate value cannot be inserted into a unique index. [Table name, Constraint name]"

Insert statement is: "INSERT INTO TB_prdModel(modDesc, catID) values ('test', 1)"

Table TB_prdModel have 3 rows: modID (PK, Identity), modDesc (nvarchar(100)), catID (int).

Anyone have an idea how to fix this please? thanks for your time and help

0
Comment
Question by:Dominic34
  • 2
2 Comments
 

Author Comment

by:Dominic34
ID: 35087200
seems the Identity value of the column is reset to 1 after the Pull. So, either I reset the Identity to the MAX value of all the tables or I change all my tables from INT Identity to GUID. What should I do?

GUID take a LOT more memory than INT and is a pain to work with (not really user-friendly). But INT Identity could cause problem when synchronizing with multiple clients.

What is the best way to sync tables using RDA ??
thanks
0
 

Accepted Solution

by:
Dominic34 earned 0 total points
ID: 35095976
Ok, I converted all INT Identity to GUID, now it works fine. thanks to myself for the answer.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question