How I can use SQL attacehd mdf db as multiuser (for main and client user same time)

Question

0.00/5 (No votes)

See more:

Hello,
I am Using Vb.net.
I want to Use Sql Mdf Db as Attached Db (Without Sql Server).
I Already Attached Mdf File For Single User but When I am Using in Another System via Lan Or Network Drive then Error Showing Process With Another.
Please Explain How I can Work in 2 Or More System Without Sql Server With Attached Mdf File Using Localdb.

What I have tried:

"Server=(localdb)\v11.0;Integrated Security=true;AttachDbFileName=" & Application.StartupPath & "\Dbp.Mdf;"

Posted 30-Sep-22 7:18am

Soft Management

Updated 2-Oct-22 23:23pm

v2

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)

OriginalGriff · Accepted Answer · 2022-09-30T08:21:00

You can ... just stick the DB file on a shared folder and let the remote connect to it.

But ... it's a really bad idea. Yes, it can be done; yes, it can work. But every single time I've done it it's caused more problems than it's solved. Access is primarily a single user DB, and it really doesn't work well with multi user access. It'll mostly work, provided that you connect, use, and disconnect every time you use it; that you handle errors gracefully with competent retries built in; that you never make any assumptions about your data. Fail once, and it'll bite you on the ass, and bite hard.

Use SQL Server or MySql instead - it may seem like more work, but long term it's so much easier and more reliable.

Richard Deeming · Accepted Answer · 2022-10-02T23:23:00

LocalDB is, as the name suggests, a local database. Trying to share it between multiple users isn't going to end well.

And the AttachDBFileName option is an extremely bad idea. SQL Server will create a separate user instance for each running instance of your application, and you won't be able to open the same database file from multiple instances.

Instead, create a proper instance of SQL Server, and create a proper database within that instance. All of your application instances can then connect to that existing database, and there won't be any file-sharing issues.

How I can use SQL attacehd mdf db as multiuser (for main and client user same time)

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0