I have not yet tested this particular aspect of multi-database transactions. It seems to me that it *should* work the way you want it to work but this very well may be a Firebird limitation. Please ask this in a Firebird support forum for a reliable answer.

Jason Wharton

www.ibobjects.com

I have a situation where I have two connections to a single database, and I want to attach these to a single transaction.  I'm using the TIB_Transaction.AddConnection method and it seems to work well.  The problem I have is that changes posted (not committed) on the first connection aren't showing up on the second connection.  i.e. if I insert a record in a table on connection 1 then query that table on connection 2 I can't see the new record.

I'm not sure if there's a problem with my code or if this is just a limitation of Firebird (I'm using 2.5).  I know generally the AddConnection feature is used when the connections are to different databases, and in that scenario this issue wouldn't be a factor; I need it for multiple connections to a single database because I need to connect using multiple roles at the same time (sadly not possible in a single connection).

Can anyone advise?  Is what I'm trying to do possible/supported in Firebird/IBO?