Configuring an ODBC Data Source

To configure an ODBC data source, you must have an ODBC driver installed for the relational database you want to use. ODBC drivers are often automatically installed and set up when you install the relational database application.

For more information on whether an ODBC driver has been installed for a particular relational database, refer to the documentation supplied with the application.

To configure an ODBC data source:

1. Click the Start button and point to Programs, Administrative Tools, and then Data Sources (ODBC). You can also access the Administrative Tools folder from the Control Panel.

The ODBC Data Source Administrator program opens.

2. On the User DSN tab, click Add. The Create New Data Source dialog box appears.
3. Select the ODBC driver for the relational database you want to access from the list.
4. Click Finish. An ODBC Data Source Setup dialog box appears for the ODBC driver you selected.

NOTE: If you do not have the correct ODBC driver installed on your system, an error message appears instead of the ODBC Data Source Setup dialog box.

5. In the ODBC Data Source Setup dialog box, enter the required information.

NOTE: Skip steps 6-9 if you are not accessing a Microsoft Access data source and not running iFIX as a service.

6. In the System Database area, select the Database option.
7. Click the System Database button. The Select System Database dialog box appears.
8. Select the system database (usually C:\ACCESS\SYSTEM.MDA).
9. Make sure Exclusive and Read Only are unchecked in the Options group.
10. Click OK in the ODBC Data Source Setup dialog box. The new data source appears in the Data Sources dialog box.
11. Click Close.

See Also

How Do I...