Setting up a Database Connection with a Data Connection File
Another option for the setup of a database connection is to select or specify a UDL file.
A UDL file is a Microsoft data connection file that contains all the settings needed for a specific OLE-DB provider in order to establish an ADO connection to the database.
To make use of this option, click the Data connection file (.udl) setting in the Create Connection dialog. Enter a name for the file or click Browse to select an existing file. If the user name and password for the database are subject to frequent changes, it is better to use a UDL file. Then you only have to modify the settings in your UDL file and don't need to make any changes within your SDL Passolo projects.
A UDL file can be created as follows: Use the Windows Explorer to create a new text file in a directory of your choice, and give this new text file the extension UDL. Double-click this file to open the Data Connection Assistant and configure the settings for the UDL file (see Setting up a database connection by means of a connection string).