MSDTC, distributed applications and XA compatability
We have an application comprising of two discrete components (a .NET 1.1 COM+ component, and a legacy ODBC component), which operate on the same SQL Server data (same database rows) within the same distributed transaction. We use the ITransactionExport/Import interfaces to propagate the DTC transaction from the COM+ component to the legacy ODBC component. All works fine.
This soluton deploys to Windows and we support SQL Server only.
However, we have a requirement to retain the COM+ component, but to deploy the legacy ODBC component onto a Unix platform and to use a Unix RDBMS (Oracle). I envisage we will use an Oracle ADO.NET Data Provider to provide data access for the COM+ component and Oracle's UNIX RM proxy (OCI) for the legacy ODBC component.
My question is this -is the DTC capable of fully managing/co-ordinating an XA transaction where a non-Windows component needs to enlist it's database connection(s) on the XA transaction managed by the DTC?
If so, how is communication achieved between the DTC and the Unix RM proxy?
Any / all help gratefully received.
Nick Rumble
