VS C# SQL database connection string don`t work for other computers

Question

0.00/5 (No votes)

See more:

Hi.
I create app that use SQL Server File Database (.mdf) file that is located in my project folder.App is working perfectly when i am on my PC but when i try to use at on other PC i get error that patch is wrong.So is there any why to make my Connection string auto generated to Project Folder or any other why.

What I have tried:

This is my string:

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\PC\Desktop\Projects\DApp\Database.mdf;Integrated Security=True;Connect Timeout=30");

Posted 12-Jun-18 2:50am

them4rtin

Updated 12-Jun-18 3:11am

Add a Solution

2 solutions

Solution 2

C#

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\PC\Desktop\Projects\DApp\Database.mdf;Integrated Security=True;Connect Timeout=30");

It won't work, because it refers to MS SQL server installed on developement computer...

If you would like to share database in LAN, you have to enable remote connections for MS SQL Server. For futher details, please see: Configure the remote access Server Configuration Option | Microsoft Docs[^]

Then you have to change connection string[^].

Imagine, you're the one who has access to that SQL Server instance till enable remote connections. In other words, SQL server have to broadcast its existence in a LAN ;)

Posted 12-Jun-18 3:13am

Maciej Los

Updated 12-Jun-18 3:20am

v2

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)

User 7429338 · Accepted Answer · 2018-06-12T03:02:00

Solution 1

You should not hard code the path to the database, but put it in a directory intended for user data. Have a look at this excellent article[^] to help choose one.

Posted 12-Jun-18 3:02am

User 7429338

Comments

Maciej Los 12-Jun-18 9:15am

Sorry, but the main problem is that - that connection string refers to MS SQL Server installed on developement computer. Please, see my answer.

[no name] 12-Jun-18 9:20am

It's referring to a local database in a file, and in the working example it's in the user's desktop directory. I'm not sure I follow you in the assumption that it's meant to be a shared database?

Maciej Los 12-Jun-18 9:24am

No. I mean, OP have to enable remote connections to MS SQL Server to be able to "share" database between clients.

[no name] 12-Jun-18 9:25am

If the clients don't have MS SQL Server installed, yes.

Maciej Los 12-Jun-18 9:28am

Why to write database application if there's no way to share data between clients?

them4rtin 12-Jun-18 9:43am

Is my first time i forget about that hard. Also i think about that hard coded string . But i found a why to fix that. By using this
(string con=System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Database1.mdf";)