Running a .net sql database application from shared folder?

Question

0.00/5 (No votes)

See more:

.NET4.5

I am developing an application that uses a Sql Server Express LocalDB file to store data, but now that I am almost done my client says that they want it to be accessed by multiple users (I think 4 at most) at the same time.

I am very new to .NET (this is the first application I write) and know nothing about writing a network application. On top of this they do not even have a server yet, though they are planning on getting a NAS, and neither do I so I couldn't test a network application.

I was thinking of deploying the database to a Shared folder in the target PCs, but I'm not sure if it would cause problems when more than one user tries to write to the database at the same time. Is this a viable solution?

Any suggestions would be very welcome.

Posted 31-Aug-15 1:14am

Member 11244347

Updated 31-Aug-15 2:40am

v2

Add a Solution

Comments

AndrewCharlz 31-Aug-15 7:30am

y dont u go for sql server Express instead, Install sql server in a system and then connect all the available pc via tcp/ip now you can connect to this DB from all the other system's. this allows N no of app to be connected to a server.

http://streetrat.in/Articles/Content/Things-to-know-before-using-LocalDB100.aspx?RatHistory=100

Member 11244347 31-Aug-15 8:38am

It is Express, actually. I'll edit the topic to make it clear.

Philippe Mori 31-Aug-15 8:59am

SQL Express will generate an error if you try to use a file on a shared network folder. Thus, you really need to install SQL Server Express on a server to do that. As indicated in Solution 1, LocalDB will probably won't work in that case.

Member 11244347 31-Aug-15 12:27pm

Thank you @AndrewCharlz and @Philippe. I have looked into connecting via tcp/ip and it should solve the problem with little hassle.

AndrewCharlz 31-Aug-15 23:30pm

exactly Mr.Philippe

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)

AndrewCharlz · Answer 1 · 2015-08-31T01:43:00

Solution 1

http://streetrat.in/Articles/Content/Things-to-know-before-using-LocalDB100.aspx?RatHistory=100[^]

This issue has been elaborated here, and i have mentioned why LocalDB cannot be used as server.

Posted 31-Aug-15 1:43am

AndrewCharlz