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?