ODP.NET

Well, this is not question but information.
I spent a lot of time-actually whole a day-to find out this. I couldn't find the answer in here, so I decide to write this to help others. :)

When you try to use DTC with ODP.NET & OraMTS, you might be encountered following error.

Oracle.DataAccess.Client.OracleException : unable to load OraMTS

Installed software is:
- ODP.NET 9.2.0.2.0
- OraMTS 9.2.0.1.0
- etc..

Someone answered about this problem like below:
- OraMTS installed?
- Check \OracleHome\Bin Path
- Check OraMTS.dll in the patch

However, my setup was perfect. I mean all things was OK.
I can manipulate DB when I don't use transaction-required option.

And Someone said..
- Some machine worked well, but other didn't.

The problem is in OraMTS.DLL.
This DLL is Debug version and required MSVCRTD.DLL.
If you are VC/VC++ Developer, maybe you could have MSVCRTD.DLL in your system32 folder.
But if not, it might not be there.
In recently OS(such as W2k, XP) MSVCRTD.DLL was renamed to MSVCRxxd.DLL.
So you should copy & rename MSVCRxxd.DLL(recommended MSVCR70d.DLL) to system32 folder.

After do above, all works well..

I hope Oracle would correct this. sigh. :(
(Perhaps already patched?)