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).
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:
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.
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.