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.
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.
The following files are included in the Microsoft ODBC Driver Manager 3.0 (or later):
Within QMF for Windows, 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 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:
The following ODBC drivers have been tested for use with QMF for Windows.
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 |