Tip for determining connection strings

Here is a nice little cheat for setting up a connection string:

1. Create a text file and name it so that it has a file extension of “udl”
2. Double click the file: the “Data link properties” dialog will open.
   
3. Setup your connection parameters by going through all the tabs in the dialog.
4. Click ok to save the connection settings.
5. Open the UDL file in notepad. Voila, you have your connection string!