Technology

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.

• For Windows XP select new Microsoft Data link. A new file will be created with name 'Microsoft Data Link.udl'. Rename the file, but keep the .udl extension.
• For Windows 2000 select new Text Document. A new file will be created with name 'New Text Document.txt'. Rename the file and give it a file extension .udl.

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:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=LCPI.IBProvider.1;Password=masterkey;Persist Security Info=True;User ID=sysdba;Data Source=f:\interbase\dispatcher.gdb;auto_commit=True