498 views

ODBC Error Messages: Determining if the query size should be shortened

  

Symptoms
  • query timed out while processing
  • translation of query exceeds the WHERE clause buffer limit

Cause
If you receive an error message indicating that a query exceeds the WHERE buffer limit, it is likely that a large query caused it to fail.
Resolution

If you receive the following error message when running a query, [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine] Translation of query exceeds the WHERE clause buffer limit of X., a large query run through the ODBC driver likely caused the WHERE clause buffer limit to fail.

The WHERE clause buffer limit is not configurable. Shorten the query size either by limiting the number of rows and tables it is requesting or by removing all duplicate field references in the WHERE clause.

As a general rule, optimize the query so there are as few WHERE clauses as possible.

 

Article Information

Last Updated:2015-05-02 09:59:13
Published:2014-06-12