rda.pull error

[KevinC]

I am using rda to pull data from my PC's SQL Server database. My code
works fine with an HP Ipaq 2210, but with a Dell X5, I am
inconsistently getting an SqlCeException after some of the tables
have been pulled. Some of the time, one or two tables are pulled
successfully before the error occurs.

The first sqlError is "SQL Server CE encountered a problem opening the
SQL Server CE Database" (native error - 28559). The second sqlError
is "The file is not a valid database file. An internal error has
occured."

Here are the relevent code snippets:

foreach (string sName in AimsNames)
{
rda.Pull(sName, "select * from " + sName,
remoteConnectString, RdaTrackOption.TrackingOnWithIndexes);
}

private string[] AimsNames =
{
"aimAGYNME", "aimAGYCOV", "aimAGYMST",
"aimAGYCTL", "aimAGYSUS", "aimAGYRTE"
};

Thanks for any help!

 

[Alberto Silva - MVP]

Where is your databse stored, in conventional RAM or in any other kind of
storage, similar to the IPAQ File Store?

Regards,
Alberto Silva

 

[KevinC]

I store the database on a SanDisk 256mb SD card. I tried swapping the
card for a new one and that did the trick - the pull works fine with the
new card.

 

[Alberto Silva - MVP]

That's odd...

Anyway, storing the database on a SD or CF card is not a good idea if you
need performance. I made some tests on iPaqs and the most performant place
to store the databases is conventional RAM, then slower it's the iPaq file
store and even slower, memory cards.
The differences are more noticed in write opeations, like INSERTS

Regards,
Alberto Silva