Hi Could somebody please help? I am using FreeTDS with DG4ODBS. Isql connects without issue, but sqlplus gives error.
[oracle@BIDB1 admin]$ isql -v order xxx xxx
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select count(*) from dbo.job;
+------------+
| |
+------------+
| 159149 |
+------------+
SQLRowCount returns 1
1 rows fetched
SQL> select * from dual@order;
select * from dual@order
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.com.xx)(PORT=1521))(CONNECT_DATA=(SID=order)))
ORA-02063: preceding line from ORDER
Process ID: 39460
Session ID: 176 Serial number: 37875
SQL> select PARENTJOBID from dbo.job@order;
select PARENTJOBID from dbo.job@order
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from ORDER
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = orderware
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
#HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
HS_LANGUAGE = AMERICAN_AMERICA.WE8MSWIN1252
HS_FDS_SUPPORT_STATISTICS = FALSE
HS_FDS_DELAYED_OPEN=FALSE
#
# ODBC specific environment variables
#
set ODBCINI = /etc/odbc.ini
HS_FDS_FETCH_ROWS=1
HS_RPC_FETCH_REBLOCKING = OFF
$>dg4odbc
Oracle Corporation --- MONDAY SEP 18 2017 11:49:50.818
Heterogeneous Agent Release 11.2.0.4.0 - 64bit Production Built with
Oracle Database Gateway for ODBC
$ more /etc/odbc.ini
[order]
Driver = FreeTDS
Server = orderdb
Trace = yes
Database = reporting
Port = 1433
User = xxx
Password = xxxxx
TraceFile=/tmp/freetds.log
$ more /etc/odbcinst.ini
[FreeTDS]
Description=Freetds v 0.95
Driver=/usr/lib64/libtdsodbc.so
UsageCount=2
Trace = yes
TraceFile = /tmp/tds.log
error log..........
SQL text from hgopars, id=1, len=43 ...
00: 53454C45 43542041 312E2250 4152454E [SELECT A1."PAREN]
10: 544A4F42 49442220 46524F4D 20224442 [TJOBID" FROM "DB]
20: 4F222E22 4A4F4222 204131 [O"."JOB" A1]
Exiting hgopars, rc=28500 at 2017/09/18-11:55:53 with error ptr FILE:hgopars.c LINE:577 FUNCTION:hgopars() ID:SELECT list of size 0 is not valid
Entered hgocomm at 2017/09/18-11:56:05
keepinfo:0, tflag:1
00: 44425249 4E2E5249 4E4E4149 2E434F4D [xxxx.COM]
10: 2E41552E 64626662 61383066 2E31302E [.AU.dbfba80f.10.]
20: 33332E32 39383831 [33.29881]
tbid (len 37) is ...
00: 44425249 4E2E5249 4E4E4149 2E434F4D [xxxx.COM]
10: 2E41555B 31302E33 332E3239 3838315D [.AU[10.33.29881]]
20: 5B312E34 5D [[1.4]]
cmt(0):