DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
I installed Oracle Gateway for MSSQL version 11.2.0.3.0 to a separate Oracle Home (platform is IBM AIX 6.1 64-bit). After setting up listener, init.ora file etc., I created database link and tried few queries (database version 11.2.0.2.0 with patches 12827726, 12827731 applied). All queries result in error message:
--------
SQL> select count(*) from s4user@imosprodnew;
select count(*) from s4user@imosprodnew
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Legacy Driver]20450 {20450}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Changed language setting to us_english.
{01000,NativeErr = 5703}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Changed database context to 'imosprod'. {01000,NativeErr = 5701}
[Oracle][ODBC SQL Server Legacy Driver][SQL Server]The number '042100421004210042110421104211042190421904219' is out of the range for numeric
representation (maximum precision 38). {22003,NativeErr = 1007}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Incorrect syntax near
'042100421004210042110421104211042190421904219'. {10103,NativeErr = 102}
ORA-02063: preceding 3 lines from IMOSPRODNEW
-----------
Trace file shows:
-------
Heterogeneous Agent Release
11.2.0.3.0
....
ODBCINST set to "/app/oragw/product/11.2.0.3/dg4msql/driver/dg4msql.loc"
RC=-1 from HOSGIP for "LIBPATH"
LIBPATH from environment is "/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib"
Setting LIBPATH to "/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib"
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/app/oragw/product/11.2.0.3/dg4msql/driver/lib/odbc.so"
....
treat_SQLLEN_as_compiled = 1
....
uencoding=UTF8
....
##>Connect Parameters (len=226)<##
## DRIVER=Oracle 11g dg4msql;
## Address=10.1.0.20\IMOS;
## Database=imosprod;
#! UID=IMOS;
#! PWD=*
## AnsiNPW=Yes;
## EnableQuotedIdentifiers=1;
## IANAAppCodePage=2252;
## OctetSizeCalculation=1;
## PadVarbinary=0;
## SupportNumericPrecisionGreaterThan38=1;
Exiting hgogenconstr, rc=0 at 2013/06/06-14:54:21
Entered hgopoer at 2013/06/06-14:54:21
hgopoer, line 231: got native error 0 and sqlstate 20450; message follows...
[Oracle][ODBC SQL Server Legacy Driver]20450 {20450}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Changed language setting to us_english. {01000
,NativeErr = 5703}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Changed database context to 'imosprod'. {01000,NativeErr = 5701}
Exiting hgopoer, rc=0 at 2013/06/06-14:54:21
hgocont, line 2688: calling SqlDriverConnect got sqlstate 20450
....
DriverName:HGmsss23.so, DriverVer:06.11.0052 (b0047, U0046)
DBMS Name:Microsoft SQL Server, DBMS Version:10.00.4000
....
Entered hgopoer at 2013/06/06-14:54:21
hgopoer, line 231: got native error 1007 and sqlstate 22003; message follows...
[Oracle][ODBC SQL Server Legacy Driver][SQL Server]The number '042100421004210042110421104211042190421904219' is out of the range for numeric represe
ntation (maximum precision 38). {22003,NativeErr = 1007}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Incorrect syntax near '0421004210042100421
10421104211042190421904219'. {10103,NativeErr = 102}
Exiting hgopoer, rc=0 at 2013/06/06-14:54:21
hgoulcp, line 1932: calling SQLGetTypeInfo got sqlstate 22003
Exiting hgoulcp, rc=28500 at 2013/06/06-14:54:21 with error ptr FILE:hgoulcp.c LINE:1932 ID:SQLGetTypeInfo: LONGVARCHAR
hostmstr: 349326: RPC After Upload Caps
hostmstr: 349326: RPC Before Exit Agent
hostmstr: 349326: HOA Before hoalgof
Entered hgolgof at 2013/06/06-14:54:21
tflag:0
Entered hgopoer at 2013/06/06-14:54:21
hgopoer, line 231: got native error 0 and sqlstate 20131; message follows...
[Oracle][ODBC SQL Server Legacy Driver]20131 {20131}
Exiting hgopoer, rc=0 at 2013/06/06-14:54:21
hgolgof, line 180: calling SQLDisconnect got sqlstate 20131
Exiting hgolgof, rc=28500 at 2013/06/06-14:54:21 with error ptr FILE:hgolgof.c LINE:180 ID:Disconnect
hostmstr: 349326: HOA After hoalgof
hostmstr: 349326: HOA Before hoaexit
Entered hgoexit at 2013/06/06-14:54:21
Entered hgopoer at 2013/06/06-14:54:21
hgopoer, line 231: got native error 0 and sqlstate HY010; message follows...
[DataDirect][ODBC lib] Function sequence error {HY010}
Exiting hgopoer, rc=0 at 2013/06/06-14:54:21
hgoexit, line 126: calling SQLFreeHandle got sqlstate HY010
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:126 ID:Free ENV handle
hostmstr: 349326: HOA After hoaexit
hostmstr: 349326: RPC After Exit Agent
-----------------
Could this be some sort of incompatibility between DG4MSQL version 11.2.0.3.0 and RDBMS version 11.2.0.2.0?
I did not find anything relevant by searching, really (apart from one thread suggesting that this could be caused by misconfigured Linux OS, but my platform is AIX)