Re: SQL CE 3.5 and Data Loss on SD Card

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,
I don't have a Motorola rugged device with me right now - maybe next week I will - but as far as I remember, on settings, system tab page, there's an applet that will let you change how the SD card is accessed, with 2 options, one named like 'SD-MMC' and another which I don't recall. You should switch to this one.

Also make sure you have the latest firmware, I think that some had corruption issues on storage cards.

--

Alberto Silva
http://www.moving2u.pt - R&D Manager
http://msmvps.com/AlbertoSilva - Blog
Microsoft MVP - Device Application Development


"Johannes Wikman" <JohannesWikman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9B2F8906-FD0C-4995-BEEA-3BEE3CB241D1@xxxxxxxxxxxxxxxx
Hi Alberto,

Do you know what settings you had to do? Were experiencing similar problems
on MC70 devices.

Best regards,
Johannes

"Alberto Silva" wrote:

I don't remember the exact name of the control panel applet - I can check it
tomorow - but I do remember we had to change the SD card access from 'MMC'
to 'SD'.

Alberto Silva

"lindstjp" <lindstjp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ACBAB6C1-72F8-4E72-A660-B84FEE090CEB@xxxxxxxxxxxxxxxx
> We are using Symbol MC9094 devices. I will check with the supplier
> concerning the firmware. Do you know what settings you adjusted in
> control
> panel?
> -- > Thank you,
> Jeff
>
>
> "Alberto Silva" wrote:
>
>> Hi Jeff,
>> Are you using a consumer device or a rugged device? Do you have the
>> latest
>> firmware on it?
>>
>> The reason I ask is that some devices power down the SD card while in
>> stand-by, which may lead to database corruption. We had that issue >> with
>> Symbol MC70 devices, which was fixed with a newer firmware and some >> new
>> settings on the control panel.
>>
>> Alberto Silva
>>
>> "lindstjp" <lindstjp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:FE586FB9-4E39-4503-B9C1-2D493EB488D7@xxxxxxxxxxxxxxxx
>> > We have an application running on a hand device that utilizes SQL CE
>> > 3.5
>> > for
>> > data storage and retrieval. The database is resides on a 2 Gig SD
>> > card.
>> > We
>> > are seeing ocassional data loss after the device is powered off and
>> > back
>> > on
>> > in the field. In testing we cannot reproduce the behavior. The >> > data
>> > loss
>> > is
>> > significant, recently we lost about 2.5 hours worth of transactions
>> > from
>> > one
>> > database. The database itself doesn't report corrupt, it just comes
>> > back
>> > on
>> > reboot as if it cleanly rolled back all transactions. Printouts and
>> > user
>> > testimony indicate it was functioning correctly prior to the data >> > loss.
>> > We
>> > suspect the SD card may be the culprit. Any thoughts?
>> > -- >> > Thank you,
>> > Jeff
>> >
>> > __________ Information from ESET Smart Security, version of virus
>> > signature database 3990 (20090406) __________
>> >
>> > The message was checked by ESET Smart Security.
>> >
>> > http://www.eset.com
>> >
>> >
>> >
>>
>> __________ Information from ESET Smart Security, version of virus
>> signature database 3990 (20090406) __________
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 3994 (20090407) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 3994 (20090407) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4290 (20090730) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4290 (20090730) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



.

Relevant Pages

  • Re: SQL CE 3.5 and Data Loss on SD Card
    ... devices we have experienced only one corrupted SDF database. ... I attribute our success to opening a connection just before every DB access ... some code that checks to make sure the SD card is ready before attempting ... The message was checked by ESET Smart Security. ...
    (microsoft.public.sqlserver.ce)
  • Re: Linksys WMP54G Wireles Adaptor Wont Work; Or I Dont Know How To
    ... issues you are seeing with your linksys card? ... of the replacement modem WEP key. ... ADDRCONF: wlan0: Link is not ready ... KWIFIManagerand it's configuration settings module, ...
    (Ubuntu)
  • Re: Newbie video problems
    ... go back into the settings and it's back on generic. ... icon resembling 2 computer screens show near the time? ... I think I know what graphics adaptor to tell it to use, ... Identifier "Generic Video Card" ...
    (Ubuntu)
  • Re: MediaCenter freezes / hangs for one and a half minute
    ... What happens if you run the media center set up again? ... ATI does not have native drivers for Win7 for this some of their card, ... I also noticed that sometimes, it hangs while stepping through pics, ... The message was checked by ESET Smart Security. ...
    (microsoft.public.windows.mediacenter)
  • Re: MediaCenter freezes / hangs for one and a half minute
    ... with regards, ... the same one which the card manufacturer shipped with the card the first day it was released and it could be years out of date. ... But suddenly, it hangs again, and stays hanged for a minute ... The message was checked by ESET Smart Security. ...
    (microsoft.public.windows.mediacenter)