O$ 10.1: ODBC Error "The statement could not be executed directly"

[Asif Jabbar]

Hi List,

After upgrading to Omnis Studio 10.1, we’re getting the following error from StatementObject.$execdirect() call for insert statements.  Any clues as to why and what can be done to resolve this.

StatementObject.$errortext():"The statement could not be executed directly”

Upon research it seems like the ODBC buffer gets filled up and it can’t process any SQL statements once the buffer is full.

Thank you much in Advance,

Asif Jabbar