OLEDB - create an UDL
OLEDB = Object linked and Embedded for Database.
UDL = Universal Data Link
How to create a UDL file.
Open the Windows Explorer. Right-click in the directory where you want to store the file and then click New.
Double click the file you created. The Data Link Properties screen will open. To start configuring an OLEDB connection, select the Provider tab.
Select the driver to use and press Next or select the Connection tab.
Specify the data source an the security info. The way you setup the Udl can be dependent on the driver or the database type you are using.
Please refer to the manual of your OLEDB driver to configure the other parameters. Security settings are configured under the Advanced tab. The driver specific parameters are set under the 'All' tab.
After pressing Ok your udl file will be ready for use. You can review the the file by using a normal text editor. In the sample we used, your udl file may look like:
PROMES BVBA - Laarsebeekdreef 14 2900 Schoten Belgium
Tel: +32 475 87 69 38 - E-mail: email@example.com