sqlce concurrency issues

  • Thread starter Thread starter Michael Morisoli
  • Start date Start date
M

Michael Morisoli

I am developing my first SqlCe application and have just run into a
concurrency problem. When I have two applications running on the same PDA
at the same time accessing the same local SqlCe database they encounter file
sharing errors.

Is this by design in SqlCe or is there some switch I am not setting.

The goal is to have a "background" process performing some sync operations
while the foreground application continues to function.

Thanks, Mike
 
SQL CE 2.0 is a single user database engine. The only solution I can suggest
is to open the database as needed and then close it. Every time you open it,
be prepared to handle an exception. You could consider moving the database
access into a 3rd application, with which you will be communicating one way
or another
 
Back
Top