|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Saturday, June 27, 2009 3:07 AM
Points: 13,
Visits: 59
|
|
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?
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, November 05, 2009 3:08 AM
Points: 83,
Visits: 36
|
|
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
|
|
|
|
