Using A UDL file to get an ADO connection string

Create an empty text file and name it “test.udl”. Double-click the file, go through connection process, then re-open the file in a text editor. Connection string is inside there.