Subject RE: [IBO] RE: IB_TRANSACTION PROBLEM
Author Support List
Peter,

> I just migrated to IBO Version 4.9 Release 12 Build 233 from 4.8 Build
> 7 (beta).
>
> I have 2 components on a form:
>
> IB_Transaction1 [TIB_Transaction]
> Properties:
> IB_Connection := DataModule1.IB_Connection1
> IB_Connection1 := DataModule1.IB_LocalConnection
>
>
>
> IBODelCFQuery [TIBOQuery]
> Properties:
> IB_Connection := DataModule1.IB_LocalConnection IB_Transaction =
> IB_Transaction1 SQL := DELETE FROM CARRIED_FORWARDS
>
>
> The code is:
>
> IB_Transaction1.StartTransaction;
> try
> IBODelCFQuery.ExecSQL;
>
>
> When I run the code, I get the following error:
>
> ISC ERROR CODE:335544324
> ISC ERROR MESSAGE: Invalid database handle (no active connection)
>
> Other parts of my software where IB_TRANSACTION are used also have
> similar error messages. I didn't have this issue with 4.8.7. Have
> there been any changes with the method IB_TRANSACTION is used.
>
> Please advise.

I am not aware of anything that should have affected this.

Will you please update to the latest Beta and test it using that?
Also, I strongly advise that you avoid 4.9.x entirely if you are coming from
4.8.x. This is because I took a wrong turn and forced everything to ANSI
string types as a way to migrate into Delphi 2009 Unicode strings. It wasn't
until IBO 4.9.13.x that I got this all straightened out.

It will be much easier to migrate your code to the latest Beta.

Jason Wharton