10g & Unable to load DLL (oramts.dll). at System.Data.OracleClient

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Did I miss something, or is this just lame?

With Oracle 10g & distributed transactions I get:

System.DllNotFoundException: Unable to load DLL (oramts.dll). at System.Data.OracleClient.UnsafeNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) ...

If I rename the 10g version of the dll (oramts10.dll) to the 9i name (oramts.dll) everything works just fine. Is there a hotfix or registry setting to handle this? Thanks.
 
This is an Oracle change, not an MS issue. If you go to otn.oracle.com and
look up ODP.NET, you will find that the two Oracle versions of the ODP (pre
10g and 10g) are different, as well. MS has not updated its implementation
for 10g yet.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
JimT said:
Did I miss something, or is this just lame?

With Oracle 10g & distributed transactions I get:

System.DllNotFoundException: Unable to load DLL (oramts.dll). at
Click to expand...
System.Data.OracleClient.UnsafeNativeMethods.OraMTSJoinTxn(HandleRef pCtxt,
ITransaction pTrans) ...
If I rename the 10g version of the dll (oramts10.dll) to the 9i name
Click to expand...
(oramts.dll) everything works just fine. Is there a hotfix or registry
setting to handle this? Thanks.
 
Yes Oracle changed the DLL name, they've been changing DLL names with major releases for years. If you look at ...\SOFTWARE\Microsoft\MSDTC\MTxOCI there's provision for specifying the release specific names for a couple of Oracle DLL's. My point/question is, who dropped the ball with the oramts.dll? Why can't I just update a registry entry for the Oracle release I'm using?

Would someone with Microsoft care to comment? Thanks
 
JimT,
Thanks for the post, I am currently looking into this and will let you know
if I find anything.

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.


JimT said:
Yes Oracle changed the DLL name, they've been changing DLL names with
Click to expand...
major releases for years. If you look at
....\SOFTWARE\Microsoft\MSDTC\MTxOCI there's provision for specifying the
release specific names for a couple of Oracle DLL's. My point/question is,
who dropped the ball with the oramts.dll? Why can't I just update a
registry entry for the Oracle release I'm using?
 
Back
Top