Re: Looking for Fast Database

Ginny,

in that time, it was VB.Net 2005, .Net CF 2.0 and SqlCe 2.0.
Ok, development hasn't stop - but if it is corrupted, try to say this your
boss.

Regards,

Carsten Unterberg | Test-Framework
http://test-framework.blogspot.com/


"Ginny Caughey MVP" <ginny.caughey.online@xxxxxxxxxxxxxx> schrieb im
Newsbeitrag news:A6F575CC-057B-4D13-8263-DF105E2EE888@xxxxxxxxxxxxxxxx
Carsten,

Which version of SQL CE were you using at the time? We really don't hear
about that problem much these days, and with SQL CE 3.5 you can set the
flush interval to flush writes to "disk" more often. Here's a thread about
that issue:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.ce&tid=40a84bb0-1779-407c-8741-50d741c32147&cat=en_US_35530dfa-6032-4a6b-9ce6-fec11fa4823a&lang=en&cr=US&sloc=&p=1

--

Ginny Caughey
Device Application Development MVP


"Carsten Unterberg" <carsten.unterberg@xxxxxxxxxxxxxx> wrote in message
news:eqwTB9jeJHA.3968@xxxxxxxxxxxxxxxxxxxxxxx
Hi Doug,

a couple of years before, I developed an applicaiton for WinCe 4.2 with a
database-file (sdf) on a SD card. At first, everythink was fine, but a
few month later, we had problems wirh corrupted sdf-files on the SD
cards.
We had at lot of trouble with that failure. I don't know exactly why that
happens. Some people say, that it is something with the power managment.
I think, it is better to be careful.

Regards,

Carsten Unterberg | Test-Framework
http://test-framework.blogspot.com/



"Doug" <joker@xxxxxxxxxxx> schrieb im Newsbeitrag
news:2aa6df32-143b-4024-a056-81d2172ce105@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Carsten,

Can you explain exactly why an SD card (or any removable flash memory)
shouldn't be used for the database file?

On Jan 19, 7:54 am, "Carsten Unterberg"
<carsten.unterb...@xxxxxxxxxxxxxx> wrote:

btw, you shouldn't store database files (*.sdf) on a sdcards. it can be
dangerours and can corrupt your database.






.

Relevant Pages

  • RE: Paste Append
    ... Both of your posts lead me to believe that the database is corrupt. ... creating a new database file and importing everything from the old to the ... If the OLE field is still a problem, create a Make Table query based on the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Problem using Replace function with Memo field
    ... I will try creating a new database file and copy the data to the new ... > field in these particular records are stored) has become corrupt. ... > your data from a Corrupt Microsoft Access MDB" at ... >>whenever I attempt in code to change the field value of a memo field that ...
    (microsoft.public.access.modulesdaovba)
  • Re: Product Activation suddenly appearing after 18 months
    ... > Unplug or disconnect your internet connection. ... Press f8 twice and chose safe mode. ... encrypted database file, and MS has yet to create a database file that ... PA is just corrupt! ...
    (microsoft.public.windowsxp.general)
  • Re: My sqlmobile data file corrupted
    ... Passwords are cases sensitve remember. ... >> corrupt. ... >> error that said "The database file may be corrupted. ...
    (microsoft.public.sqlserver.ce)