DB2 graphic  QMF Version 8

Configuring ODBC data sources

To configure an ODBC data source, click Tools --> ODBC Data Source Administrator. After you select the driver for your data source, the configuration options and steps are driver specific. If your configuration requires you to specify an authentication method for the data source, be sure that you specify the same method used by the database server.

You must configure your ODBC data sources as either system data sources (system DSNs) or user data sources (user DSNs). A system data source is defined for the computer and accessible to all users that log on to that computer. A user data source is defined only for a particular user on the computer.

ODBC data sources typically require the following types of information:

Additionally, for some data sources, you can select advanced options on data source configuration pages.

Note: Consider naming your data source to reflect your database name, unless you have a naming conflict among multiple databases you intend to use with QMF Visionary.

After you have configured one ODBC data source for a particular database server, you can autoconfigure additional data sources for other databases on that server, as described in the following section.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004