> >>>OTOH, is it possible for all these different DB connections to share

the

> >>>same transaction across all the threads?
> >>>
> >>>Thanks!
> >>>
> >>>Jonathan Neve.
> >>>
> >>>
> >>>
> >>NO
> >>
> >>
> >
> >You can, however, create a cross-database transaction using
> >two-phase commit :-)
> >
> >
> That sounds very much like what I was proposing... What's the difference?

A cross database transaction is started for each database, not simply
shared between database.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com