MTS and ORACLE - Myth or reality ?

[pgrenette]

Hi,

I'm trying (for several weeks now) to enlist an Oracle connection in a MTS transaction.
It fails whatever I try.

Using the Microsoft ODBC driver, my SQLConnect statement returns SQL_ERROR and the associated message is always the same (who never had this f%#2ing message with MTS ?):

"Microsoft][ODBC Driver Manager] Failed to enlist on calling object's transaction"

But when I'm looking in the Event Viewer Application, my Oracle seems ready to go:

"The description for Event ID ( 0 ) in Source ( COM Contexts ) could not be found. It contains the following insertion string(s): Failed to enlist in DTC: SQL state NA000, native error 0, error message [Microsoft][ODBC driver for Oracle][Oracle]ORA-00000: normal, successful completion."

hum...

Now, if I use the Oracle ODBC driver 8.00.0500 instead the Microsoft one, I have also an error with the following message in the event viewer:

"The description for Event ID ( 0 ) in Source ( COM Contexts ) could not be found. It contains the following insertion string(s): Failed to enlist in DTC: SQL state HYC00, native error 0, error message [Oracle][ODBC]Optional feature not implemented.."

My God ! That's not what they said in the documention...


Any Help ?


Here is my configuration:

Oracle server 8.0.5 (NT server)
Oracle client 8.0.5 (NT 4 workstation + SP4.0)
MTS 2.0 + Patches
Microsoft ODBC Driver for Oracle: 2.573.292700
Oracle ODBC Driver: 8.00.0500

If anybody was able to enlist in MTS transaction with Oracle, please, tell me how !