Matt Glace, a co-worker of mine showed me a cool trick for creating connection strings that I thought I would share.

- Create a blank text file on your desktop. But instead of saving it with a txt extension save it with a udl extension. Name it whatever you want. UDL stands for Universal Data Link.

- The icon should now show a little computer in it. Double-click on it to open it back up.

- Go through the tabs and fill out the information like you would in VS or SMS. Test conneciton and then save.

- Right click on the file but this time open with notepad. Your connection string is right there.

Read the complete post at http://www.dotnetmafia.com/Home/tabid/37/EntryID/124/Default.aspx