To Configure a Data Source Using OLE DB

You can use OLE DB to establish a UDL configuration file that points to an external database table.

1. Use Microsoft ODBC to set up a data source.
2. At the Command prompt, enter dbconnect.
3. On the dbConnect Manager, right-click Data Sources and click Configure Data Source.
4. In the Configure a Data Source dialog box, do one of the following:
   • Create a data source. In the Data Source Name box, enter a name for the data source. Click OK.
   • Edit an existing data source. In the Data Sources list box, select a data source. Click OK.
5. In the Data Link Properties dialog box, Provider tab, select Microsoft OLE DB Provider for ODBC Drivers. Click Next.
6. In the Use Data Source Name box, enter the name of the data source you want to configure.
7. Click Test Connection to verify that your configuration is working properly.

   If the connection fails, verify that the settings are correct. For example, spelling errors and case sensitivity may be the cause of a failed connection.

8. Click OK.