Loading

Connection string for connecting Database (.mdf)

ravinder mulukuntla

how to write Connection string for connecting Database (.mdf) file not attaching?

IS this better way to connect the Database through .mdf file?

"Data Source=192.168.123.123,1433;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Test.mdf;User ID=sa;Password=1234"

it is working but can i use this AttachDbFilename attribute on this is it better or not?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dileep Kumar Patel12y ago
Whatever you are using all is well but whether you are using .mdf file put the file in app_data folder and you can give path instead of this path AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Test.mdf; to AttachDbFilename=Test.mdf; .
This is more comfertable at that time you will shift project one system to another system.
0