Posted on: 1/23/2012 3:06:00 PM | Views : 1258

If I use a local SQL Server (Express) database, and want to interact with it in code, how can I specify the connection string? On my dev machine it is: "Data Source=RORYGALLAGHER42\SQLEXPRESS;Initial Catalog=Local_UniClientNextGen;Integrated Security=True;Pooling=False"; ...but on other machines, once it is installed there, the required connection string will presumably be something like: "Data Source=NAPDYN_1\SQLEXPRESS;Initial Catalog=Local_UniClientNextGen;Integrated Security=True;Pooling=False"; "Data Source=KIPDYN_2\SQLEXPRESS;Initial Catalog=Local_UniClientNextGen;Integrated Security=True;Pooling=False"; "Data Source=UNCLE_RICO_3\SQLEXPRESS;Initial Catalog=Local_UniClientNextGen;Integrated Security=True;Pooling=False"; "Data Source=PEDRO_4\SQLEXPRESS;Initial Catalog=Local_UniClientNextGen;Integrated Security=True;Pooling=False"; "Data Source=DEB_5\SQLEXPRESS;Initial Catalog=Local_UniClientNextGen;Integrated Security=Tru ...

Go to the complete details ...