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 http://stackoverflow.com/questions/173209/how-do-i-connect-to-an-mdf-microsoft-sql-server-database-file-in-a-simple-web — Gonzalo.-, Jul 13 '12 at 14:50

score 1 · Accepted Answer · answered Jul 13 '12 at 14:51

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 '12 at 14:51

seeker

3,255
7
36
68

1

I agree, I always try to specify the full path, just to be safe. +1 – Kris Gruttemeyer Jul 13 '12 at 14:53

score 0 · Answer 2 · answered Jul 13 '12 at 19:33

0

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

answered Jul 13 '12 at 19:33

antew

949
8
17

How to change SQL connection strings data source?

2 Answers2