How to change SQL connection strings data source?

Question

I'm beginner in C# and SQL Server. Currently I’m developing a program, the problem is my database file is in DB folder inside project folder. When I try to detach the database file in SQL Server Management Studio it gives an error:

"Data Source=localhost;Initial Catalog=test;Integrated Security=true"

When I the change data source to this

"Data Source=db/test.mdf;Initial Catalog=test;Integrated Security=true"

it gives an error. I don’t know how to insert database file with project to InstallShield to create setup file.

check this stackoverflow.com/questions/173209/…

Gonzalo.-
– Gonzalo.-

2012-07-13 14:50:20 +00:00
Commented Jul 13, 2012 at 14:50 — Gonzalo.-
– Gonzalo.-, Commented Jul 13, 2012 at 14:50

seeker · Accepted Answer · 2012-07-13 14:51:53Z

1

You may set up connection using DATA-> new data source dialog. There you will set up all the parameters visually. I think the problem here is that full path is not specified. Also path should be in quotes.

answered Jul 13, 2012 at 14:51

seeker

3,3637 gold badges42 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kris Gruttemeyer Over a year ago

I agree, I always try to specify the full path, just to be safe. +1

antew · Accepted Answer · 2012-07-13 19:33:15Z

0

Also whenever you need help on connection strings for any database http://www.connectionstrings.com/ is a great reference.

answered Jul 13, 2012 at 19:33

antew

9698 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to change SQL connection strings data source?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related