From VB can i have transactions to different databases and it should be a
single transaction.

eg:

BeginTrans
    insert some records to DB2 tables
    update some records in  Oracle table
Committrans

ErrorHandler:
Rollbacktrans

I don't want to use MTS. At present i have attached these tables in an
Access .mdb file.  So Access takes care of the transaction.
Other than this roundabout way, do we have any other options.

Thanks in advance

Shelly

DB2.BeginTrans
Oracle.BeginTrans
    insert some records to DB2 tables
    update some records in  Oracle table
DB2.Committrans
Oracle.Committrans

ErrorHandler:
DB2.Rollback
Oracle.Rollback

The only problem I could see would be if somehow you succeeded on the first
commit and
got an error durring the 2nd commit. Not very likely unless the 2nd database
crashed between
updating some records and committing.

Vince