DB2 graphic  QMF Version 8

ODBC

ODBC enables QMF for Windows to access non-DB2 databases, including Microsoft Access, Oracle, Sybase, and Informix. QMF for Windows can catalog the data source information from these non-DB2 servers and allows you to assign a catalog server. ODBC does not require you to bind packages because dynamic SQL is used.

To access an ODBC data source using QMF for Windows, To access ODBC data sources using ODBC, QMF for Windows must be able to establish an ODBC connection from the local host to the remote host via the ODBC driver manager.

QMF for Windows requires the Microsoft ODBC Driver Manager (R) 3.0 (or later) to access ODBC data sources on various databases. The ODBC driver managers may also be used. Connections are supported to any data source that supports the ODBC protocols listed in your ODBC driver manager.

Note:
QMF for Windows can connect using ODBC, as long as the ODBC protocol is supported by the data source, the ODBC driver manager, and the appropriate driver is installed on your computer. The connectivity information is defined in your ODBC driver manager.

Work with your in-house networking staff to implement and support your network configuration. QMF for Windows Technical Support cannot provide support for these issues.

ODBC driver manager files

The following files are included in the Microsoft ODBC Driver Manager 3.0 (or later):

What ODBC supports

Within QMF for Windows, ODBC supports:

Table 29. What ODBC Supports
ODBC supports ODBC does not support Data sources
All isolation levels, as long as they are supported by data sources Large objects (LOB) Cross Access
Binding methods by row and column Stored procedures iSeries
Auto-commit-off, as long as they are supported by data sources Bookmarks and any operations regarding bookmarks MS Access
Long, varying binary and character values, up to 32,700 bytes Any interval data types MS Excel
User DSN, machine DSN, and file data sources SQL Server
The use of the ODBC cursor library, if needed Oracle
The use of multi-row block fetch, if the ODBC driver supports it dBASE
Paradox
Delimited Text Files (*.CSV, *.TXT)

Data sources

Data sources are referenced in the QMF for Windows program by their DSN names. A user ID and password are required to make the connection if it is required by the ODBC data sources.

Most data sources can be used as long as the particular data source drivers are available. Here is a sample list of data sources that can be accessed by QMF for Windows via ODBC:

ODBC drivers

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

Table 30. Tested ODBC Drivers
Model Version Manufacturer
CrossAccess 32 2.21.3777.00 CrossAccess
Client Access ODBC Driver (32-bit) 7.00.00.00 IBM
Client Access ODBC Driver (32-bit) 5.00.08.00 IBM
Informix 3.80 (32-bit) 3.80.00.10841 IBM
IBM DB2 ODBC Driver 7.01.00.00 IBM
IBM DB2 ODBC Driver 6.01.00.00 IBM
IBM DB2 ODBC Driver 5.02.00.00 IBM
SQL Server 3.70.06.23 Microsoft
Microsoft dBase Driver (*.dbf) 4.00.3711.08 Microsoft
Microsoft dBase VFP Driver (*.dbf) 6.00.8428.00 Microsoft
Microsoft Excel Driver (*.xls) 4.00.3711.08 Microsoft
Microsoft Access Driver (*.mdb) 4.00.3711.08 Microsoft
Microsoft Paradox Driver (*.db) 4.00.3711.08 Microsoft
Microsoft Text Driver (*.txt, *.csv) 4.00.3711.08 Microsoft
Oracle ODBC Driver 8.01.06.00 Oracle


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