ansaurus

Question

Answer 1

A:

Is it same process is using multiple threads to access this sdf file, or only one thread. When it says some other "PROCESS" is accessing the file, what is it? Is it VS, or something else. I think you can use the remote process viewer to see which processes in the device are using this SDF file. If you could see seperately which handles are for which processes in a device, that would be great. Even otherwise, just try to delete the sdf file (or move/rename it), after killing some processes on the desktop. That might tell you what is the offending process.

sivaramakrishna 2009-06-02 10:27:59

No they're two separate applications. Both are trying to open the same database. One opens the connection and when the second one tries to open it it gives the file sharing violation error. Im using this connection string to connect.conn = new SqlCeConnection("Data Source=\\\Program Files\xx\DB.sdf");

Marcom 2009-06-02 10:46:53

Answer 2

+2 A:

SQL Compact does support multiple connections to the database, even back with version 3.0. How is the first process opening the database? For example, the mobile Query Analyzer from 3.0 and 3.1 did open the database exclusively, effectively locking it from any other process.

ctacke 2009-06-02 12:59:18

both application use the same connection string SqlCeConnection conn = new SqlCeConnection("Data Source=\\\Program Files\xx\DB.sdf");conn.Open();the first application that opens the db withtout probs. the second one throws the error.

Marcom 2009-06-02 15:18:22

I can tell you that in certain cases, it doesn't matter that SQL CE supports multiple connections. You can still get the sharing violation error.For instance, on the desktop if the SDF file is on the user's local machine, multiple processes/connections can be made to it. Place that SDF file on a network share, and it's a different story. Only 1 process can access it at a time.I wonder if its the same situation when opening on a mobile device.

CBono 2009-06-03 20:19:16

It's well documented that it won't work on a network share (http://www.pluralsight.com/community/blogs/jimw/archive/2007/02/19/46151.aspx). It does work fine on a device - I have a few solutions that require multiple processes using the same database file.

ctacke 2009-06-04 01:56:53

so I am doing something wrong. Do I need to set some extra parameters in the connection string?

Marcom 2009-06-04 07:38:21

Answer 3

+1 A:

The problem was the connection string .....

"Data Source=\\\Program Files\xx\DB.sdf" apparently opens the database as a single user

using

"Data Source=Program Files\xx\DB.sdf" opens the database normally...

Marcom 2009-07-16 16:22:14

Answer 4

A:

SQLCE 4 Community Technology Preview is out. It supports multi user scenario and access from multiple threads of the same process.

It does not suffer from the same problems as SQlCE 3.5. Works well on 256 connections.

Merc 2010-07-13 20:41:32

ansaurus

tags:

views:

answers:

Sql ce 3.0 Database multiuser

related questions