The invalid transaction handle problem is most likely because you have a
statement/dataset connected to a connection and transaction that are not
themselves referencing one another. This is something the BDE would never
allow you to do in the past. Now that you can have a transaction separated
out, you are just not using it correctly.

No idea about a generic OLEDB provider for ADO.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "DennisCons" <denniscons@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 29, 2002 10:07 AM
Subject: [IBO] Accessing 2 dbs - invalid transaction handle (expecting
explicit transaction sta


> I am new to using IBO..
>
> I am trying to convert an ISAPI dll , uses BDE , 2 IB databases, T
> session
> to IBO as I get BDE initialization problems.
>
> I am starting with a simple, using a TIBOdatabase , TIBOQuery ,
> Tdatasource,
> TDBgrid. ..can connect to one db, access data.
>
> When I try to connect to a second IB database using a second
> TIBOdatabase, a
> second TIBOQuery, datasource , grid etc. When I activate the query I
> get
>
> ISC error code : 335544332
> ISC error message
>
> invalid transaction handle (expecting explicit transaction start)
>
> statement
> TIBOinternaldataset "form1.iboquery1.(Tibointernaldataset>
>
>
> Using a TIB_Transaction doesn't seem to help, although my
> understanding was
> you don't need it with TIBODatabase. I have tried many things with
> alll the
> properties etc, but cannot make it work.
>
> I have been using delphi for a long time now, is it just me or are
> these IBO
> components just confusing to work with.
>
>
> Can anyone recommend a good OLEDB provider for IB / Firebird, I am
> also
> going to try to use ADO
>
> DennIs Cons.
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>