Using SQL Server Database on sharing basis

Question

0.00/5 (No votes)

See more:

SQL-server-2000

Hi,
My application needs to run on a sharing network. Different connections from different computers hit database at the same time. SSCE 3.5 gives File sharing violation error.

I added .mdf file and tried the application but it did not run on second computer.
Do I need to setup SQL Server Express in a certain way?

Thanks

Posted 9-Jan-12 22:13pm

Furqan Sehgal

Add a Solution

1 solution

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)

Mehdi Gholam · Answer 1 · 2012-01-09T22:16:00

Solution 1

A single instance of SQL server can use a MDF file only.

Just connect to the IP address or computer name of your SQL server for the other machines instead of attaching a MDF file for each.

EDIT:
Assuming computernameoftheserver is name of the hosting database and dbname is your database name :

C#

SqlConnection con = new SqlConnection("data source=computernameoftheserver;integrated security=sspi; initial catalog=dbname;");
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from tablename", con);
Dataset ds;
sda.Fill(ds);

Posted 9-Jan-12 22:16pm

Mehdi Gholam

Updated 9-Jan-12 22:59pm

v2

Comments

Furqan Sehgal 10-Jan-12 4:53am

Can you give little example, I make connections using dataset

Mehdi Gholam 10-Jan-12 5:00am

I have updated the answer.

Furqan Sehgal 10-Jan-12 8:51am

Thanks ! but I use typed datasets so I just change the dataset connection string?

Mehdi Gholam 10-Jan-12 9:03am

Yes, exactly.

Furqan Sehgal 10-Jan-12 9:05am

Is there any way to use SSCE database on sharing basis? Forums say no but I have found Microsoft documentation, they say yes. Upto 256 connections at a time.

Furqan Sehgal 10-Jan-12 9:22am

But when my client installs the application, how can I know the computer name and do I need to change the connection string for every client?

Mehdi Gholam 10-Jan-12 9:32am

Put it in a configuration file.

Furqan Sehgal 10-Jan-12 10:24am

Any examples please? Also I am using typed Datasets. How to edit the connection string, I tried but it is read only.