sql 2005 connection string problem

Question

0.00/5 (No votes)

See more:

Hi,

I have a data base in a c# project in my hard disk, but when i move my project to other computer and it's address change , it doesn't work , I think it's for this code:

C#

SqlConnection sqlconnection=new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\c#\LAS\LAS\mm.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");

can anyone help me to solve this problem?

Posted 27-Feb-11 1:07am

mehdi_k

Updated 27-Feb-11 6:55am

thatraja

v2

Add a Solution

4 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)

Abhinav S · Answer 1 · 2011-02-27T01:10:00

Solution 1

You have hardcoded the URL for the database.
That is not the best approach. You need to place your database on a central server and allow all client machines to point to that server.

If it is a local database, make sure the database is always in the location you have given here.

Posted 27-Feb-11 1:10am

Abhinav S

Comments

CS2011 27-Feb-11 7:26am

Good suggestion...But This it's kind of learning project. my 5 anyway for the suggestion.it's always a good practice

CS2011 · Answer 2 · 2011-02-27T01:12:00

Solution 2

Look if you have your files in the drive with different name. As per now The connection string says it's in drive "G:\". if so change is to appropriate one and it should work fine

Posted 27-Feb-11 1:12am

CS2011

Comments

mehdi_k 27-Feb-11 9:32am

can you give a sample code?

CS2011 27-Feb-11 20:49pm

I can give you an example

See As per now your your connection string is "(@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\c#\LAS\LAS\mm.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");" and as per this your database file would in drive G:\

now Assume you have moved your to C:\ Drive and the folders remain same then your connection string would be changed to

"(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\c#\LAS\LAS\mm.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");"

mehdi_k 28-Feb-11 1:33am

my problem is how it should change!
when my app is exe i can't change it's code!!

Ramalinga Koushik · Answer 3 · 2011-02-27T17:34:00

Solution 4

Don't hardcode the URL for the database, instead of that use it as

SqlConnection sqlconnection=new SqlConnection(@"Data Source=.\\SQLEXPRESS;database="Training";Integrated Security=True;Connect Timeout=30;User Instance=True");

Hope this will solve your problem.

Posted 27-Feb-11 17:34pm

Ramalinga Koushik

sk saini · Answer 4 · 2011-02-27T17:25:00

Since problem resides in your connection string because you have hardcoded the database URL so you we need to specify a path that should be automatically detected by the system while connecting on other system also.

Substitute your connection string with the following and make sure to attach your database with databases option in SqlServer 2005 before executing your code:

string constr;
constr = "Data Source=.\\SQLEXPRESS;database="Library";Persist Security Info=False;Integrated Security=True;";

Substitute 'Library' database in above code with your database name only without specifying any path.