Configuring the Data Link for IBM DB2

The data link specifies the database server name and other database-related information, such as the username and password of a user with full access rights to the database server.

  To configure the data link for IBM DB2:

  1. From Windows Explorer, double-click the UDL file that you created.

  2. From Data Link Properties, select the Provider tab, and from the OLE DB Providers list, select IBM OLE DB Provider for DB2 Servers.

  3. Click Next.

  4. On the Connection tab:

    1. Select Use data source name option.

      This option selects the data source name that you established during the IBM DB2 installation.

      Note:

      If the data source name is not displayed in the list, go to the Client Configuration Assistant, Database Properties box, and select As a system data source.

    2. Enter a username and password.

      Note:

      Ensure that the user is granted privileges to create, update, and delete tables.

  5. Select Allow saving password.

  6. Click Test Connection.

  7. On the Test Connection Succeeded box, click OK.

  8. Click OK to save the connection and close the dialog box.

  9. Right-click the UDL file and select Open to set the UDL file as the system data link file.