I have an MTS component which calls a program on the AS400 via IBMDA400 OLEDB. When I set the MTS component to "NoTransactions" the call works. When I set the MTS component to "RequiresTransaction", I get an error "No such interface supported 80004002"
So my question is: Does IBMDA400 OLEDB support MTS transactions? In the OLEDB TechRef it says the you can use ADO transactional functionality which suggests that AS400 OLEDB supports MTS/COM Transactions. Other IBM articles says that SQL Transactions are not supported. Niether of these answers my question.
Furthermore, I have read that the COMCAT.dll is the cause of the problem. I have checked my COMCAT.DLL and it is version 5.2195 so its fairly recent.
Any help would be appreciated.