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.
- Use Microsoft ODBC to set up a data source (see Use ODBC to Create a Configuration File).
-
Click
dbConnect menu
Data
SourcesConfigure
.
At the command prompt,
enter DBCONNECT
- In the Data Link Properties dialog box, the Provider tab, select Microsoft OLE DB Provider for ODBC Drivers. Choose Next.
- Enter the name of the data source you want to configure in Use Data Source Name.
- 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.
- In the Microsoft Data Link dialog box, click OK.
- Click OK.
