DB2 graphic  QMF Version 8

Connect using ODBC

Select this option to connect to the database server that you are configuring in the server definition file using ODBC connectivity. All DB2 and non-DB2 data sources are accessed via ODBC in the same way, as long as the data sources provide ODBC support. To connect to multiple data sources using ODBC, you need to configure each data source individually in the server definition file or dynamically enable all ODBC data source definitions.

Database applications' call functions in the ODBC interface are implemented in database-specific modules called drivers, which isolate applications from database-specific calls. ODBC drivers are loaded at run time. A new driver has to be added to access a new DBMS; it is not necessary to recompile or re-link the application.

For ODBC servers, QMF for Windows supports:

For ODBC servers, QMF for Windows does not support bookmarks and interval data types

The following ODBC drivers have been tested for use with QMF for Windows:

ODBC enables QMF for Windows to access DB2 and non-DB2 databases, such as Microsoft Access, Oracle, Sybase, and Informix(R).

Machine data source name

Use this field if the ODBC data source you are configuring in the server definition file is defined to your local machine's registry as a user data source name (DSN) or a system DSN. From the Machine data source name list, select the name of the ODBC data source from the list of available user and system DSNs. The machine data source name is the name of an ODBC data source that is defined in the registry of a client machine, either as a user data source name (DSN) or a system DSN.

Machine DSNs are available to all logged-on users of that machine. Machine DSNs are stored on the system with a user-defined name. The DSN provides the information that:

Note:
ODBC user DSNs and system DSNs defined to your local machine's registry are listed in the ODBC Data Source Administrator dialog box.

File data source name

Select this option if the ODBC data source you are configuring in the server definition file is a file data source name. File data source names can reside on your local machine or another machine or server that is part of your network.

The file data source name is the name of a file whose contents define how to connect to an ODBC data source. A file data source can reside on any client or server machine in the network. Unlike a machine data source, in which the connection information resides in the local machine's registry, file data sources can be shared by many users across a network.

Advanced

Optional: Use the Advanced button to specify driver-specific connection string keywords and their values that are to be used when connecting to a database server using ODBC connectivity. The syntax and allowable values for the keywords are determined by the driver; refer to the driver documentation for more information.

The Advanced DSN Settings window opens where you specify the connection string keywords that will be included in the connection string for the ODBC connection.


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