Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

DataDirect "ORA-28545" error with Oracle Heterogeneous Services (hsodbc) or Oracle Database Gateway for ODBC (dg4odbc)

« Go Back

Information

 
Article Number000006577
EnvironmentProduct: Connect/Connect64 for ODBC driver
Exact version: All supported versions
Platform/OS: All supported platforms
Databases: All supported databases
Application: Oracle Heterogeneous Services, Oracle Database Gateway for ODBC
Question/Problem Description
When attempting to connect through Oracle's Heterogeneous Service to an ODBC driver, the mentioned error is thrown.
Steps to Reproduce
Clarifying Information
Error MessageError : ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from <DBLINK>
Defect/Enhancement Number
Cause
This error message can be returned due to
 
  1. Missing or incorrect setting of ODBC environment variables
  2. Mixing a 32-bit Oracle hsodbc executable with a 64-bit ODBC driver or  mixing a 64-bit Oracle dg4odbc executable with a 32-bit ODBC driver
 
Resolution
 
  • Ensure the environment variables are defined.
XXXX=<ODBC_Install_Dir>\lib   (where XXXX = LIBPATH on AIX ; LD_LIBRARY_PATH on SOLARIS/LINUX; SHLIB_PATH on HP)
 
ODBCINI=<ODBC_Install_Dir>\odbc.ini
 
  • Verify the bitness of the hsodbc / dg4odbc executable (file hsodbc ; file dg4odbc) and install the corresponding 32-bit or 64-bit ODBC drivers.
32-bit applications require 32-bit ODBC drivers while 64-bit applications require 64-bit ODBC drivers. On Unix, run the "file" command on the hsodbc/dg4odbc executable under $ORACLE_HOME/bin/ to check the bitness.
 
 
Workaround
Notes
Attachment 
Last Modified Date6/20/2019 3:28 PM