Re: Issue with SQL Server 2005 Mobile and SD Cards?
- From: joe_w <joe@xxxxxx>
- Date: Fri, 21 Sep 2007 16:43:57 -0700
On Sep 20, 2:07 am, "Peter Hartlén" <pe...@xxxxxxx> wrote:
Hi!
I'd say there is no perfect solution using database on SD-card, and many
people would strongly advice against it.
There are several factors that help making life easier though if you for
some reason must have your db on an external disk.
1. Make sure the device has good drivers for the SD-card. We had several
problems with this in the beginning, but our device manufacturer eventually
solved this. Problems tend to arise when the device power-ups, the
application targetting the db is running, and the card drivers problably
doesn't initialize the card fast enough.
2. Make sure you use professional cards. Cards are so cheap nowadays anyway.
We've been using SanDisk Ultra II cards quite successfully. Older/Slower
cards has shown more tendency to malfunction. As your file system seems
corrupted from time to time I sugges trying this solution first.
Anyhow, if you are targeting WM5 or later I suggest putting the SD-card on
device memory instead. IIRC WM5 has some kind of data recovery handling, so
the database should be pretty safe (I'm not 100% sure on this).
/ Peter
"adulador" <msmolin...@xxxxxxxxx> skrev i meddelandetnews:1190232761.639342.282430@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Our application uses a database on an SD Card. We encounter strange
errors sometimes when we attempt to access it.
The errors are: 0x80004005, Description: Unspecified error; Minor = 0.
Once this occurs it never can recover. A soft reset sometimes solves
it, but not reliably.
Another observation is that after this error occurs, if you look at
the SD card in File Explorer, the file listing looks all messed up.
for example some folder and file names are,
========
Meta(====
nt="Robo.HEL
}boxboxol.wh
the file sizes are wacked out too. One said 1.58G and the card is only
512 MB.
The file system has gone corrupt or something.
Is there an issue with SQL Server 2005 Mobile and SD Cards?
Is there a setting i need to use when the DB is on an SD Card?
Environment Info:
DB: Sql Server 2005 Mobile Edition
in OLEDB C++.- Hide quoted text -
- Show quoted text -
We also are having major problems with SQL Server 2005 Mobile. Our
Databases are on the SD cards as well since they can get very large.
We use the San Disk Ultra II and have had good luck with stability of
the SD card but SQL will terminate my .NET application during any type
of Database action to the table like an Insert statement. There is no
way to catch the error - it just termiates the program. However, I
have found that if I open the database with Query Analyzer before I
run my program then everything works most of the time. We do open/
close/dispose of all SQL CE objects like connections, commands, etc
because that was necessary back in SQL CE 2.0 where it would corrupt
the tables if we didn't do this process.
The device is an HHP Dolphin 9500 unit running PPC 2003 SE - I've not
tested with any other O.S. yet.
.
- Follow-Ups:
- Re: Issue with SQL Server 2005 Mobile and SD Cards?
- From: adulador
- Re: Issue with SQL Server 2005 Mobile and SD Cards?
- From: Peter Hartlén
- Re: Issue with SQL Server 2005 Mobile and SD Cards?
- References:
- Issue with SQL Server 2005 Mobile and SD Cards?
- From: adulador
- Re: Issue with SQL Server 2005 Mobile and SD Cards?
- From: Peter Hartlén
- Issue with SQL Server 2005 Mobile and SD Cards?
- Prev by Date: Re: RDA Concurrency Issue
- Next by Date: Re: URGENT: Not enough storage is available to complete this operation. - I am going crazy over this.
- Previous by thread: Re: Issue with SQL Server 2005 Mobile and SD Cards?
- Next by thread: Re: Issue with SQL Server 2005 Mobile and SD Cards?
- Index(es):
Relevant Pages
|
