Connection Strings Tip

November 20, 2007 - SQL
Connection Strings Tip

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.



Leave a Reply

Your email address will not be published. Required fields are marked *