Platform: ASP.NET, COM+, Oracle 10g (10.1.0.2.0), all installed on the same system. Background:
I am using ADO.NET APIs in my COM+ components to insert and update records in the Oracle DB. Everything was working fine including the COM+ Transaction support, till I was using the Microsoft ODBC for Oracle (MSORCL32.DLL ver 2.576.3959.00). When we migrated the application to support Globalization, it was found that Microsoft ODBC for Oracle does not support Unicode and therefore we have to use the ODBC driver (SQORA32.DLL ver 10.01.00.02) shipped by Oracle to get the Unicode support. Issue:
After changing to the Oracle ODBC Drive (SQORA32.DLL ), we found that all the COM+ module that requires Transaction support is not working and throwing "Unable to enlist in the transaction" error.
Can you please suggest me the possible solutions preferably without much changes to the code?
Hope I had share enough information to explain the problem, please do let me know if more information is required.