Jason,
looks like MTS is tightly bound to XA:
"
Microsoft Transaction Server Distributed Transaction Coordinator
MTS uses the services of Microsoft Distributed Transaction Coordinator (MS DTC) for transaction coordination. MS DTC is a system service that coordinates transactions that span multiple resource managers. Work can be committed as a single transaction, even if it spans multiple resource managers, potentially on separate computers. MS DTC was initially released as part of Microsoft SQL Server™ version 6.5, and is included as part of MTS. DTC implements a two-phase commit protocol that ensures that the transaction outcome (either commit or abort) is consistent across all resource managers involved in a transaction. MS DTC supports resource managers that implement OLE Transactions, X/Open XA protocols, and LU 6.2 Sync Level 2.
"
Why do you need to use MTS?
An old version of MySQL's JDBC faked XA capabilities.
Hmm... maybe you can instruct MTS to accept a non-XA resource?
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php