RDA Pull Error Using Microsoft SQL Server Compact Edition 2005

Hello dear all.



I am using a Compact Framework 2.0 on a mobile 5.0 with a local Microsoft SQL Compact Edition 2005 database. The backend database is a Microsoft SQL Server 2005 and I am trying to pull a 45000 rows table (the table has 2 varchars(8) forming a primary key and an INTEGER column).



The statement I issue is the following:

rda.Pull(table.TableName, table.TableQuery, Program.RdaOleDbConnectionString, RdaTrackOption.TrackingOnWithIndexes, table.TableName + "Errors");



The application works perfectly when I am pulling smaller tables (up to 15000 rows) but when I try to pull this one I get the following error details:



sqlCeEx
{""}
base {System.SystemException}: {""}
Errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
HResult: -2147024882
Message: ""
NativeError: 0
Source: "Microsoft SQL Server Compact Edition"


Please have in mind that the handheld on which I deploy does not have an extra storage card.



I have done a thorough internet search and I have found no solution to this problem. I truly rely on you to find the solution.



Thanks in advance,



Steliosvcy.