RDA Issues

I can use RDA to copy small table’s fine. However if I try to copy a larger table (50,000)+ rows I get an error on the Pull method.

I get an error with two Values:

Message "The OLE DB Execute method failed. The SQL statement is not valid. [,,,SQL statement,,]" String

Message "The identity column must be an integer data type and cannot be NULL. [,,,,,]" String

I have tired TrackingOff but it did not do anything.

Like I said small tables work fine I can use Pull fine but larger tables fail. I thought at first it was because I was using a view instead of a table but when I queried the table directly I got the same error. I am using an int as my identiy column in the database.

Is there a row return limitation? Maybe its timing out, is there a way to expand the time out?

Currently I am using a web service for this but it is so many rows the handhelds run out of memory in the middle. (Although when it's done it only takes about 1.2 MB of database space)

The other idea I had was to have the server create the database and the handheld just downloads it but when I do a Normal .NET project it crashes whenever I make a CE object call.