Really neat trick using MDAC (Microsoft Data Access Components) to create connection strings for various data types.
1. Create a new text file somewhere useful and rename it xxxx.udl
2. Double click on the file to open it.
3. Now your looking at the ‘Data Link Properties’ dialog box
4. Pick your connection details and click ok.
5. Open the file in a text editor (Notepad++!!!) and grab your complete connection string.