Sharing an embedded database over network

Question

0.00/5 (No votes)

See more:

I don't have so much experience on DBMS. I made a program with C# that uses SQL-CE as database, it works perfect, but I want to use shared database with my friend. When I moved to database sdf file to shared folders when I insert or update a row it gives an exception;

There is a file sharing violation. A different proccess might be using the file.

Here's my connection string:

C#

System.Data.SqlServerCe.SqlCeConnection vcon = new System.Data.SqlServerCe.SqlCeConnection("Data Source=" + DBPath);

Can you suggest me a way to share a database?(embedded or not) A tutorial could be awesome cuz I'm beginner.

Thank you.

Posted 27-Jan-14 11:10am

Emre Ataseven

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vedat Ozan Oner · Answer 1 · 2014-01-27T11:55:00

Solution 1

don't use SQL-CE. this is not for such things. you need a database server which serves as data source over a network :) search google with "database server"

Posted 27-Jan-14 11:55am

Vedat Ozan Oner

Comments

Emre Ataseven 28-Jan-14 17:13pm

There will be only 2 users nothing more. Isn't installing database server too much for this purpose? What about Ms Access? Could it be used as shared? Thank you.

Vedat Ozan Oner 29-Jan-14 3:22am

It is not about the number of users, it is about how. sql-ce db is just a file. it becomes meaningful when your process loads related drivers and reads the content of sql-ce file, so it is suitable for mobile device applications. a server stores data, but it also manages data, data access, security, integrity etc, when many (more than 1) users are included, which is your case.

Matt T Heffron · Answer 2 · 2014-01-27T14:37:00

Solution 2

SQL-CE runs in-process and is NOT for shared DB applications. (More for kiosk or stand-alone applications.)
SQL Server Express is the free edition of SQL Server:
Download SQL Server 2012 Express with SP1[^]

Posted 27-Jan-14 14:37pm

Matt T Heffron