Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to load OraMTS

384939Jan 8 2003 — edited Jul 2 2008
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?)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2008
Added on Jan 8 2003
7 comments
6,479 views