June 26, 2009 at 10:51 pm
Hello,
I am using SQL Compact Edition database 3.1 .Database is on Server.
I want the same database to be accessed by multiple Users.Does SQL Compact Edition 3.1 support
mulitple users database access?If yes then how can we allow doing such facility?
When more than one user open connecion at same time it gives error "File Violation Error."
How can I solve this problem?
July 7, 2009 at 5:49 am
I believe that SQL Compact Edition is meant for single user; it is not a complete database. You cannot have stored procedures / triggers / enterprise options like replication, sql agent. The intended use of the CE edition is to use it alongside with a normal edition. You get the data from a normal server and place it in your Compact Edition and work with it. You can then Sync it with the main server later on.
You should probably use free Express edition or a any other editions. But if you really want to make it multi-use, then u need to expose the tables with a webservice and make your applicaitons use the webservice.
NM
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply