0

I'm working on a project with C# (vs2010 environment) this project require a SQL Server CE 3.5 database for several functions. Working on a local .sdf for one user shows no problem but when I run my project with .sdf over network it gives me sql.ce errors.

Is this problem happens because using it over lan or because using it with multiple users?

And how can I solve that issue.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Adir.el
  • 43
  • 2
  • 10
  • 1
    SQL Server CE is **NOT** designed to be used over the LAN, nor is it designed to be used by multiple users. If you need this functionality -> use SQL Server **Express** instead. – marc_s Dec 24 '12 at 08:39
  • http://stackoverflow.com/questions/1992713/sql-server-ce-in-a-multi-user-scenario-is-this-really-really-stupid – Anand Shah Dec 24 '12 at 08:40
  • is there any way to use third-part software beside sql server ? – Adir.el Dec 24 '12 at 08:42

1 Answers1

0

To use multiple users you have to try SQL Server Express Version (free) or Mysql, you can see that post it will be helpful

Community
  • 1
  • 1
Akrem
  • 5,033
  • 8
  • 37
  • 64