Easysoft ODBC-ODBC Bridge

Why do I not get a list of all the tables and columns in a database?

Article:
00103
Last Reviewed:
28th October 2008
Revision:
2

By default OOB uses metadata blockfetchmode which is an optimization speeding up the retrieval of metadata result sets. Some ODBC drivers do not work properly with metadata blockfetchmode which binds the columns in the result set and sets the row array size. The symptom is usually that you see the first two tables/columns and then every 10th table/column and all the others are missing. If you suspect you are having this problem disable metadata blockfetchmode in your DSN by either:

[1] In the Windows OOB DSN, uncheck metadatablockfetch.
[2] In UNIX, add MetaDataBlockFetch=0 to the affected DSNs in your odbc.ini file.
[3] Pass MetaDataBlockFetch=0 in the connection string.

At present we have only had this reported for the tickets.com ODBC driver and Neon Systems Shadown Connect driver for DB2.

This attribute is only available in OOB 1.0.0.13 onwards.

In versions prior to 1.0.0.13 you can do one of the following:

[1] UNIX/OpenVMS
Add

{Settings}
Flags = 0x8

to the top of an odbc.ini file in the current working directory of your application.

[2] In Windows add 8 to the registry key:

HKEY_LOCAL_MACHINE\
SOFTWARE\
EASYSOFT ODBC-ODBC BRIDGE\
CONFIGURATION\
SYSTEM\
SETTINGS\
FLAGS

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.