Issue with Native Oracle Connection and Kerberos Authentication

TrangPham · June 17, 2025, 6:55am

Hi everyone,

I'm running into a problem when trying to use a native Oracle connection in EasyMorph (v5.8.0.8). Here's the error message I get:

Error: Could not retrieve column names or expression types:
NA  Kerberos5: Authentication handshake failure at stage: Could not load file or assembly 'Oracle.ManagedDataAccessIOP, Version=4.122.21.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
NA  Kerberos5: Authentication handshake failure at stage: Could not load file or assembly 'Oracle.ManagedDataAccessIOP, Version=4.122.21.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

While investigating the issue, I came across a Stack Overflow post that suggests modifying the sqlnet.ora file to change the authentication method from Kerberos to none. I tried this, and surprisingly, it resolved the issue—the Oracle connection started working.

However, making this change disabled all of my other ODBC connections.

Has anyone encountered this issue before? Is there a way to get Oracle connections working without having to disable Kerberos authentication for everything else?

Details:
Easymorph version: 5.8.0.8
Oracle driver: Oracle in OraClient19Home1

Happy to provide more info if needed. Any help or ideas would be greatly appreciated!

Thanks in advance,
Trang

andrew.rybka · June 17, 2025, 9:03pm

Hi @TrangPham and welcome to the Community!

Kerberos authentication is not supported by the native Oracle connector, so the Oracle.ManagedDataAccessIOP.dll is not bundled with EasyMorph installers.

To make your connector work with settings different from ODBC connections, you can try to create another set of Oracle configuration files and make EasyMorph connector use those files by specifying a TNS_ADMIN custom property with the path to those configuration files:

Or you can just use an ODBC connector in EasyMorph instead of the native one.