Here is a nice little cheat for setting up a connection string:
- Create a text file and name it so that it has a file extension of “udl”
- Double click the file: the “Data link properties” dialog will open.
- Setup your connection parameters by going through all the tabs in the dialog.
- Click ok to save the connection settings.
- Open the UDL file in notepad. Voila, you have your connection string!