Database Networking (MOSC)

MOSC Banner

What are the best practices for troubleshooting Heterogeneous ODBC connections?

edited Apr 3, 2022 10:00PM in Database Networking (MOSC) 7 commentsAnswered ✓

I am trying to establish a heterogeneous ODBC connection from an Oracle 21c XE database to a Progress OpenEdge 11.7 database. I have installed a 32 bit ODBC driver on the Windows 2019 server where the 21c XE DB resides. I have set up an ODBC System DSN, tested it and it works.


I created a initTIMEDATA.ora file in the C:\app\Administrator\product\21c\homes\OraDB21Home1\hs\admin folder.


It contains;

HS_FDS_CONNECT_INFO = TimeData

HS_FDS_TRACE_LEVEL = 4

HS_FDS_TRACE_FILE_NAME = TimeData.trc


Where TimeData matches the ODBC System DSN name.

I modified the listener.ora adding;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center