XE 11.2 on Centos connecting to SQL Server using Easysoft ODBC/SQL Server driver
Easysoft iSQL and tnsping both work but if I attempt a select from the DB link in sql I get this:
ORA-28513: internal error in heterogenous remote agent
ORA-02063: preceding line from [my db link]
Apart from any suggestions as to why I am getting this error, my specific question is as follows:
I have set HS_FDS_TRACE_LEVEL = DEBUG in my HS init file but can't find the log file
I assume it should be appearing in $ORACLE_HOME/hs/log - but the log directory doesn't exist...
Any advice would be appreciated.
Answering my own question:
I created the log folder in $ORACLE_HOME/hs and granted 777 permissions.
Odd. Wouldn't have thought that would be necessary...
Now to look at the log and find the reason for the original error
For future reference, HSODBC is handled by the database folks so you'd be better off posting there for any help with that product.
This forum is for Oracle's ODBC Driver, which doesn't get used by HSODBC.