How to Quickly Obtain an OLEDB Connection String with a UDL File

Document created by kduffy on Sep 26, 2018
Version 1Show Document
  • View in full screen mode

Connection strings can be difficult to build from scratch, but some applications do not provide a Data Link Properties dialog box when making the connection.

 

To build your own in a quick manner:

1. Create a new text file

2. Change the extension of the file to .udl

3. Double click the file so that it opens the Data Link Properties dialog box

4. On the Providers tab, select the provider that you are interested in and click next

5. On the Connection tab:

    a. Enter the data source name (this the AF Database name for PI SQL Client/RTQP; the PI Data Archive name for PI OLEDB Provider; and the AF Server name for PI OLEDB Enterprise)

    b. Enter the location name (this is the AF Server name for PI SQL Client/RTQP; this is blank for PI OLEDB Provider and PI OLEDB Enterprise)

    c. Select whether to use an explicit login or to pass the user's identity to the server

    d. Select the initial catalog for the connection

6. Test the connection to make sure everything is correct:

 

7. Click ok to close the dialog box

8. Right click on the file and select "Open with Notepad"

9. The connection string has been built for you up to this point

10. Use the user guide for the provider you are using to add additional parameters

Attachments

    Outcomes