Connection string for connecting Database (.mdf)

Oct 31 2014 6:37 AM
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?

Answers (1)