Subject Expecting Explicit Transaction Start
Author Jerry Sands
I have had a problem that is driving me crazy. I am using a TIB_Cursors and
connecting its own exclusive transaction to it. The sql is a select
statement, the transaction is set to TICommited, Autocommit, and Read Only.
I prepare, set a couple parameters, and execute an APIFirst. Most of the
time this code works correctly. But it will at times error out with an
"Invalid Transaction Handle (expecting explicit transaction start)" error.
I assume IBO is handling the transactions here. I have other cursors in the
program that are implemented in the same way and I am getting the errors on
them at times as well.

I am using Delphi 7, Firebird 1.5, and IBO 4.5Ai.

Does anyone have any ideas?

Jerry Sands