CODEWITHSUNDEEP
c#sql-server-ce
Akrem
Akrem

Reputation: 4652

Can share a SQL Compact Edition 3.5 database?

I made an application with SQL Compact Edition 3.5 to be used from many user but in the test I got can't connect to databse after the first one how connected !

this is an erreur in my application or probleme with many connexion in SDF file ?

and what about Compact Edition 3.5 accept 256 connexion!

Upvotes: 0

Views: 1554

Answers (2)

Stephen Quan
Stephen Quan

Reputation: 25871

You should look at a Microsoft Locking in SQL Server CE. In a nutshell, it says multi users/application can concurrently access the SDF at the same time provided the database is not locked in a transaction.

Also, I like to mentioned that we also do not have multi user/application access to a SQL Server CE 3.1 file on a network drive. (This constraint may still be true for SQL Server CE 3.5). If you're being affected by this, you will have to ensure your SDF is being opened using a local drive reference.

Upvotes: 0

Horn
Horn

Reputation: 388

Depending on how your application behaves, you might be able to replace SQL Compact with SQLite. It can really only handle one write at a time but can handle multiple simultaneous reads. Anything more than that and you should be looking at a real SQL server.

Upvotes: 1

Related Questions