I have been using an old trick with blank .UDL file to quickly write connection strings for years.
If you don't know what I'm talking about, try this:
- Create new Text File. I usually do that on the Desktop for easy access.
- Change the extension of the file to .UDL.
- Double click the file and you get the Data Link Properties dialog.
- Fill in data for you connection and finish with OK.
- Rename file back to .TXT, double click it and it will open in Notepad.
- There, in the second line is your connection string.
But last week I found old post about macro that simplifies this process a lot. Actually I found two similar posts teaching the same tricks. The macro makes Data Link Properties accessible right from your code in VS. Really neat trick.