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


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

 

Comments (0)