Create Connection String

1) Create a file anywhere on your machine with extension as ‘UDL’ (Uniform Data Link).
2) Double click on that file.
3) Select the OLE DB Provider from Provider Tab.
4) Click on Next.
5) On Connection Tab:
a. Select/enter server name or select server name through dropdown.
b. Select Windows NT login or enter authenticated user name and password to connect.
c. Select the required database.
6) Click Ok.
7) Open the same UDL file with notepad and copy the Connection String.
Note: Copy from ‘Provider’ text except when using for connection MS Sql Server.