Easysoft ODBC-ODBC Bridge

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

By default Easysoft ODBC-ODBC Bridge uses metadata blockfetchmode, which speeds 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 10^th table/column, and all the others are missing. If you suspect you are having this problem, disable metadata blockfetchmode in your DSN by either:

• On Windows, in the ODBC-ODBC Bridge DSN, uncheck metadatablockfetch.

  -Or

• On UNIX, add MetaDataBlockFetch=0 to the affected DSNs in your odbc.ini file.

  -Or

• Pass MetaDataBlockFetch=0 in the connection string.

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

This attribute is only available in ODBC-ODBC Bridge 1.0.0.13 onwards.

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

• On UNIX/OpenVMS, add:

  {Settings}
  Flags = 0x8

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

• On Windows, add 8 to the registry key:

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

Applies To

• Products
  • Easysoft ODBC-ODBC Bridge

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•