question

sdmcnitt avatar image
sdmcnitt asked

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.
sql serverdatabase
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.