We are trying to talk with oracle 8i database through an MTS component that we have built using VB6. We are using the Oracle ODBC driver for oracle (ver 8.1.5) provided with oracle 8.1.5.
we are getting the error message:
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Oracle][ODBC]Failed to enlist global transaction with DTC
We have followed the instructions provided by oracle 8i manuals which gives a detail of talking to MTS.
Still we are getting the above error.
What do I need to do to get transactions to work? It works fine if I set the COM component as non-transactional, but that doesn't help since we need it to be transactional. I've heard that a few patches exist for Oracle but I have not found any on their website.