DTC Two Connections in one Unit of Work on One Server
Is it possible for two connections -- one from managed code /
ADO.Net and one from VB6 COM classic ADO -- on the same server to the same database to enlist in a distributed transaction? A .Net app I support calls some old VB6 dll's on Save. Both the host application and the components do database updates. I need to find a way to do all of the updates in a single unit of work or "transaction". I am not sure it is possible to marshal any connection object from the managed code into the interops -- checking on that. The database is SQL Server 2005 to 2008 R2.