Server & Client connectionstring

Question

0.00/5 (No votes)

See more:

I've managed thanks to you guys to set up my SQL-Server and I'm currently using the following connection string:

C#

public static string constr = @"Data Source=ASUS-PC\SQLEXPRESS;
                        AttachDbFilename=C:\Users\ASUS\Desktop\basededados\cybercafe.mdf;
                        Integrated Security=True;User Instance=True;";

My question is if I have to change the connectionstring for the user, or if it's the same as above.
I'm making a cybercafe application, the admin logs in and manages the users in the server, which is in my laptop. And the users log into the server from diferent computers accessing the database that is in my laptop.

Remark that the computers including my laptop(server) are going to be on the same network.

Posted 5-Mar-13 3:42am

Steven Borges

Add a Solution

Comments

Steven Borges 5-Mar-13 9:49am

Also want to say that I'm sorry for hitting on the same rock over and over again, but it's the first time I'm making such a major application and I'm quite excited about it.

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)

**Orcun Iyigun** · Answer 1 · 2013-03-05T04:02:00

Solution 1

I think this[^] is what you are looking for.

Using Settings in C# - MSDN[^]

Good luck,
OI

Posted 5-Mar-13 4:02am

Orcun Iyigun

Comments

Steven Borges 7-Mar-13 5:42am

Correct me if I'm wrong, but what you provided answered nothing of what I asked for.

Orcun Iyigun 7-Mar-13 6:39am

Well you should correct me because you are also not clear. It is really hard to understand what your question is from your question? I answered your question based on to the following sentence: "if I have to change the connectionstring for the user, or if it's the same as above." Also can you show me the line where you asked your question instead of giving justifications? And "My question is if I have to change the connectionstring for the user, or if it's the same as above." this is not clear at all..

Steven Borges 7-Mar-13 14:17pm

Just looking at the code and then the explanation is more than enough.
tl;dr: Just want to know if I have to change the data source to access my database from the laptop which is my server, knowing I'm in the same network trying to access the .mdf from another machine.