VB6 source code that demonstrates how to use Microsoft Transaction Server to handle transactions on multiple ADO data sources simultaneously. Examples of how to begin transactions how to commit transactions and how to rollback transactions.
The code should be able to do the following.
Open [login to view URL] (For example "[login to view URL]")
Open [login to view URL] (For example "[login to view URL]")
Open [login to view URL]
Open [login to view URL]
Begin transaction
make recordset changes 1 + 2
Commit Transaction or alternately rollback transaction
NOTE: THIS HAS TO BE DONE WITH 1 (ONE) COMMIT, NOT 1 COMMIT PER ADODB
## Deliverables
1) Complete source code of all work done with details of all required references and components.
2) Include sample databases so the code can be run as is when delivered, Access or SQL Server 2005
## Platform
Windows XP, VB6, ADO 2.8