How to use the ODBC driver in an XA context

%3CLINGO-SUB%20id%3D%22lingo-sub-1610133%22%20slang%3D%22en-US%22%3EHow%20to%20use%20the%20ODBC%20driver%20in%20an%20XA%20context%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610133%22%20slang%3D%22en-US%22%3E%3CP%3EI%20already%20asked%20a%20question%20in%20a%20previous%20conversation%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Fodbc-driver-17-3-preview-for-sql-server-released%2Fbc-p%2F1607775%23M1585%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Fodbc-driver-17-3-preview-for-sql-server-released%2Fbc-p%2F1607775%23M1585%3C%2FA%3E)%2C%20but%20since%20it%20is%20bit%20old%20it%20didn't%20get%20any%20attention%2C%20so%20I'm%20trying%20to%20write%20it%20here%20again%20and%20copying%20the%20text%20from%20the%20previous%20post%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWhat%20are%20the%20means%20to%20facilitate%20the%20XA%20support%20for%20other%20TM's%20than%26nbsp%3BMSDTC%20(if%20that%20even%20counts%20as%20a%20TM)%20%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20guess%20you%20should%20be%20able%20to%20use%20the%20xaswitch.lib%20to%20build%20your%20own%26nbsp%3B%3C%2FSPAN%3E%3CEM%3Eresource%20proxy%3C%2FEM%3E%3CSPAN%3E%26nbsp%3Bthat%20you%20use%20with%20a%20XA-compliant%20TM%20and%20configure%20things%20with%20OPENINFO%2C%20but%20how%20do%20you%20get%20hold%20of%20the%20connection-object%20(possibly%20created%20by%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Exa_open())%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20even%20possible%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3EKristian%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

I already asked a question in a previous conversation (https://techcommunity.microsoft.com/t5/sql-server/odbc-driver-17-3-preview-for-sql-server-released/b...), but since it is bit old it didn't get any attention, so I'm trying to write it here again and copying the text from the previous post


What are the means to facilitate the XA support for other TM's than MSDTC (if that even counts as a TM) ?

I guess you should be able to use the xaswitch.lib to build your own resource proxy that you use with a XA-compliant TM and configure things with OPENINFO, but how do you get hold of the connection-object (possibly created by xa_open()) ?

Is it even possible ?

Best regards,
Kristian

0 Replies