• gitHub
  • linkedin
  • twitter
Connection Strings Tip

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


This site uses Akismet to reduce spam. Learn how your comment data is processed.