[RESOLVED] dynamic connection string

[jmcilhinney]

restart the SQL Server service?

I did find the SQL Server Config manager and stopped the SQL Server (SQLEXPRESS) which causes the project to fail, restarted and all good.

Does this mean that any machine that wants to run this project will need to have the SQL Server Config Manager/SQL Server (SQLEXPRESS) installed and running?

i added below to appconfig file and seems to be all good, even publish, installed and tested.

 connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\My.Computer.FileSystem.SpecialDirectories.MyDocuments, expressAccountDB\DB\expressAccountsDB.mdf;Integrated Security=True;User Instance=True"

Now my settings in "My Project" also includes the custom conString

I very much doubt that that connection string actually does what you want. You can't use VB code in a connection string.