Skip to Main Content

DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Cannot enable Transactions using ODBC Adapter from a .NET based product to an Oracle 11g db

shyju_gsFeb 19 2015 — edited Feb 20 2015

Environment details:

1. 64 bit Windows Server 2012 R2 machine

2. 64 bit .NET application using ODBC connection to connect to an Oracle 11g db

3. Oracle Server is also 64 bit.

Installed 64-bit ODAC 11.2 Release 5 (11.2.0.3.20) for Windows x64 components from

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

P.S.: the Oracle Services for MTS was checked during installation.

Created an ODBC DSN using the ODBC Data Source Administrator (64-bit). This is used in the .NET application to establish connection to the oracle db.

Connectivity works fine if i do not enable transactions, but if i enable transactions i get this error:

ERROR [HY000] [Oracle][ODBC]MTS support not available, could not load ORAMTS.DLL

I see there are lots of discussions around this topic, i have tried everything but nothing has worked. I always end up with the same error.

Can someone suggest what can be done to troubleshoot this issue?

This post has been answered by Raviraja-Oracle on Feb 19 2015
Jump to Answer

Comments

Daniel # 2622182

Hm. Actually i think i found something helpful.

Using the following Update-Site i was able to install the needed Tooling ... maybe it helps someone searching for this, too!

Eclipe Update-Site for OEPE in Eclipse Oxygen:

http://download.oracle.com/otn_software/oepe/neon

cheers,

Daniel

Daniel # 2622182

Aww, that was too hasty I was not cautious and copypasted the neon URL :facepalm:

So ... I am still looking for OEPE for Oxygen ...

3260940

me too I am looking for it.

cristianoburgo

The neon version is compatible with Oxygen.

See below the proof:

https://marketplace.eclipse.org/content/oracle-weblogic-server-tools#group-details

Eclipse Versions:

Neon (4.6), Oxygen (4.7), Mars (4.5), Luna (4.4), Kepler (4.3), Juno (4.2, 3.8)

jgremmen

The proof might state that Oxygen is supported.

However, I tried to install OEPE several times on eclipse oxygen and initially it seems it does install correctly. But after restarting eclipse it tries to perform 2 tasks which never end. It completely hangs up eclipse.

Kosta-Oracle
Answer

An OEPE version that's compatible with Eclipse Oxygen is undergoing final testing and will be released soon.

Marked as Answer by Daniel # 2622182 · Sep 27 2020
Daniel # 2622182

It seems as if Kosta did supply the correct answer. A version of OEPE is currently under development.

So we only will have to wait a bit now until we can try out OEPE in Eclipse Oxygen. My guess is, they have been waiting for SR1.a because of JDK9-compatibility?

Just as a remark for future Eclipse Releasetrains ... i guess it would not hurt (and definitely be a boon for all developers using OEPE!) to be a bit more outgoing concerning information about either the roadmap and / or releases of OEPE.

cheers

Daniel

user4545379

Why is it taking so long ? It's been months since Oxygen was released, and that hardly came as a surprise. This should have been available day 1.

Right now, Eclipse Neon + OEPE is severely broken on MacOS 10.13. Again, a release that was entirely predictable and had beta's available for months, specifically so 3rd party vendors could get their act together and have their software fixed before release.

It feels like amateur hour over here.

Daniel # 2622182

Hi there,

as it seems there (now, i do not know since when) is an afais "unanounced" update site available for oxygen at

Oracle Enterprise Pack for Eclipse 12.2.1.6

cheers

Daniel

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2015
Added on Feb 19 2015
3 comments
3,015 views