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:
 In the Windows OOB DSN, uncheck metadatablockfetch.
 In UNIX, add MetaDataBlockFetch=0 to the affected DSNs in your odbc.ini file.
 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 22.214.171.124 onwards.
In versions prior to 126.96.36.199 you can do one of the following:
Flags = 0x8
to the top of an odbc.ini file in the current working directory of your application.
 In Windows add 8 to the registry key:
EASYSOFT ODBC-ODBC BRIDGE\
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.