Don't remember connection strings syntax? Use a .UDL file.

posted by  mneon (8)  16 months ago (blogs.msdn.com)

Here is a tip I shared yesterday with a customer. 

If you need to create a connection string and don't remember the syntax, here is a simple way of achieving your goal.

• In a file folder or your Windows desktop, create a text file and rename it myCN.udl (only .udl extension is important)


• double click the file


• Enter the parameters in the UI


• Close the UI


• Open myCN.udl with notepad: you get your connection string