This discussion is archived
14 Replies Latest reply: Jun 17, 2013 4:40 AM by ultradumb RSS

DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'

ultradumb Newbie
Currently Being Moderated
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)
  • 1. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated
    in general 11.2.0.2 database works with 11.2.0.3 gateway.
    How many records are stored in the SQL Server table (use a SQl Server tool to check). Could you also upload the trace file to a public share so that i can get it and check out its whole content?

    - Klaus
  • 2. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated
    Number of records is 68

    ------
    1> use imosprod;
    2> go
    Changed database context to 'imosprod'.
    1> select count(*) from s4user
    2> go

    ======
    68

    (1 rows affected)
    1>
    -----

    Trace file can be found here: https://www.dropbox.com/l/LX7LaYU239sVrjqwhexGae
  • 3. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated
    the firs difference between my gtw and you rgtw trace file is when the gateway changes the database context:
    Your trace shows:
    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}

    Mine:
    hgopoer, line 231: got native error 5701 and sqlstate 01000; message follows...
    [Oracle][ODBC SQL Server Legacy Driver][SQL Server]Changed database context to 'gateway'. {01000,NativeErr = 5701}[Oracle][ODBC SQL Server L
    egacy Driver][SQL Server]Changed language setting to us_english. {01000,NativeErr = 5703}[Oracle][ODBC SQL Server Legacy Driver]Invalid conn
    ection string attribute {01S00}



    But it continues .... and the next error you get is:
    SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
    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 representation (maximum precision 38). {22003,NativeErr = 1007}[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Incorrect syntax near '042100421004210042110421104211042190421904219'. {10103,NativeErr = 102}
    Exiting hgopoer, rc=0 at 2013/06/06-14:54:21
    hgoulcp, line 1932: calling SQLGetTypeInfo got sqlstate 22003
    => here your gateway now exists and does not even call the count(*) command

    whereas in my env the gateway the quote_char check looks like:
    HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER
    SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
    1 instance capability will be uploaded
    capno:1992, context:0x0001ffff, add-info: 0

    => the gateway uploads its capability to the HS catalog.



    I've also used the gateway on AIX and both drivers show as: DriverName:HGmsss23.so, DriverVer:06.11.0052 (b0047, U0046)

    Edited by: kgronau on Jun 7, 2013 7:39 AM

    No information about this error sqlstate 20450.
    Could you please post your listener.ora that spawns the gateway, the gateway init file and do you get this kind of error for each select (for example also for select user from dual@imosprodnew;)?

    - Klaus
  • 4. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated
    My listener.ora file:
    ------
    ADR_BASE_ORAGWLS = /app/oragw/product/11.2.0.3

    ORAGWLS =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1550))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1550))
    )
    )
    SID_LIST_ORAGWLS=
    (SID_LIST=
    (SID_DESC=
    (SID_NAME=imos)
    (ENVS="LD_LIBRARY_PATH=/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib,LIBPATH=/app/oragw/product/11.2.0.3/dg
    4msql/driver/lib:/app/oragw/product/11.2.0.3/lib")
    (ORACLE_HOME=/app/oragw/product/11.2.0.3)
    (PROGRAM=dg4msql)
    )
    )
    -----

    My initimos.ora file:
    -----
    HS_FDS_CONNECT_INFO=[10.1.0.20]/IMOS/imosprod
    # alternate connect format is hostname/serverinstance/databasename
    HS_FDS_TRACE_LEVEL=255
    HS_FDS_RECOVERY_ACCOUNT=recuser
    HS_FDS_RECOVERY_PWD=recpassW
    -----

    And the error is produced by any query I am trying to do, as well as describe etc. Apparently the gateway fails at intialization stage and won't proceed any further.

    -----
    SQL> select user from dual@imosprodnew;
    select user from dual@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
    -----

    I thought it may be something with data dictionary tables (created using ?/rdbms/admin/caths.sql) then. I have re-created objects again (run @catnohs/commit/@caths/commit through sqlplus) but it did not help.
    Must be something really simple I overlooked, I guess (some environment variable?), but I just cannot find what it is.

    Just to mention, that I have 3 gateways installed on the same server, 2 of them in main ORACLE_HOME(/app/oracle/product/11.2.0) - dg4msql and dg4odbc, version 11.2.0.2.0 and 1 in second oracle home (/app/oragw/product/11.2.0.3) - dg4msql version 11.2.0.3.

    Edited by: ultradumb on Jun 7, 2013 9:23 AM
  • 5. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated
    just to clarify, the listener ORAGWLS is located in the 11.2.0.3 Oracle gateway home. So you first make sure you correctly initialized the 11.2.0.3 gateway env, then started the gateway listener, correct?

    There's a small issue in the listener - as your gateway is installed on AIX, please change the listener ENVS parameter from
    (ENVS="LD_LIBRARY_PATH=/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib,LIBPATH=/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib")
    to
    (ENVS="LIBPATH=/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib")
    LD_LIBRARY_PATH is not required on AIX.

    Once corrected, please STOP and START the gateway listener and then type $ORACLE_HOME/bin/dg4msql. Provide the output of the gateway listener start and also when calling dg4msql from the command line.

    In the gateway init I would add HS_NLS_NCHAR=UCS2 as all nchar/nvarchar/ntext data is stored using UCS2. Also add HS_LANGUAGE=american_america.we8mswin1252

    - Klaus
  • 6. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated
    I have corrected the listener.ora to read:
    -----
    SID_LIST_ORAGWLS=
    (SID_LIST=
    (SID_DESC=
    (SID_NAME=imos)
    (ENVS="LIBPATH=/app/oragw/product/11.2.0.3/dg4msql/driver/lib:/app/oragw/product/11.2.0.3/lib")
    (ORACLE_HOME=/app/oragw/product/11.2.0.3)
    (PROGRAM=dg4msql)
    )
    )
    -----

    Listener start log:

    -----
    $ lsnrctl start oragwls

    LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 07-JUN-2013 11:21:09

    Copyright (c) 1991, 2011, Oracle. All rights reserved.

    Starting /app/oragw/product/11.2.0.3/bin/tnslsnr: please wait...

    TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
    System parameter file is /app/oragw/product/11.2.0.3/network/admin/listener.ora
    Log messages written to /app/oragw/product/11.2.0.3/diag/tnslsnr/mandbsrv/oragwls/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1550)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1550)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1550)))
    STATUS of the LISTENER
    ================
    Alias oragwls
    Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
    Start Date 07-JUN-2013 11:21:09
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP ON
    Listener Parameter File /app/oragw/product/11.2.0.3/network/admin/listener.ora
    Listener Log File /app/oragw/product/11.2.0.3/diag/tnslsnr/mandbsrv/oragwls/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mandbsrv.unicom-cy.com)(PORT=1550)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1550)))
    Services Summary...
    Service "imos" has 1 instance(s).
    Instance "imos", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    -----

    DG4MSQL command line log:
    -----
    $ $ORACLE_HOME/bin/dg4msql


    Oracle Corporation --- FRIDAY JUN 07 2013 11:23:54.383

    Heterogeneous Agent Release 11.2.0.3.0 - 64bit Production Built with
    Oracle Database Gateway for MSSQL
    -----

    Now, contents of initimos.ora:
    -----
    HS_FDS_CONNECT_INFO=[10.1.0.20]/IMOS/imosprod
    # alternate connect format is hostname/serverinstance/databasename
    HS_FDS_TRACE_LEVEL=255
    HS_FDS_RECOVERY_ACCOUNT=recover
    HS_FDS_RECOVERY_PWD=*
    HS_NLS_NCHAR=UCS2
    HS_LANGUAGE=american_america.we8mswin1252
    -----

    Still the same issue. Trace could be found at: https://www.dropbox.com/l/AdMA9B29roodRzCzVZesW9
  • 7. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated
    Really strange. Currently don't know if the error comes from the database side or from the gateway. I've tested 11.2.0.3 GTW with 11.2.0.2 DB and no issues. To check if it is a generic issue, do you have somewhere an 11.2.0.3 Oracle database or can you install/create an 11.2.0.3 database from scratch to check the gateway with this release?

    Thanks,
    Klaus

    Edited by: kgronau on Jun 7, 2013 11:58 AM
  • 8. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated
    I do not have 11.2.0.3 installed anywhere yet, but I have tried to access MSSQL data through this gateway from one of our legacy systems running Oracle 9.2.0.8 for AIX 5.3 64-bit with same result. I will try to install minimal 11.2.0.3 DB to a separate oracle home within next few days.

    +"[Oracle][ODBC SQL Server Legacy Driver][SQL Server]The number '042100421004210042110421104211042190421904219' is out of the range for numeric representation (maximum precision 38)."+

    I've got a gut feeling that this error is somehow related to SQL queries to data dictionary issued by the gateway itself before processing user SQL. Maybe, lack of a CAST to FLOAT of that long number above or something.

    Edited by: ultradumb on Jun 7, 2013 5:37 PM
  • 9. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated

    Should not be a problem - but you can also try to reproduce it by creating a demo table at the SQL Server side and by entering some demo records. Then feel free to post the create and insert statements when you reproduced the issue and I'll have a look.

     

    - Klaus

  • 10. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated

    I created test table and inserted data (using FreeTDS tsql tool):

     

    -----------------------------

    locale is "en_US.UTF-8"

    locale charset is "UTF-8"

    1> use imosprod

    2> go

    1> create table TEST_MSSQL (PKEY integer, DATA varchar(20))

    2> go

    1> insert into TEST_MSSQL values (1000,'Data for key 1000')

    2> go

    1> insert into TEST_MSSQL values (2000,'Data for key 2000')

    2> go

    1> select * from TEST_MSSQL

    2> go

    PKEY    DATA

    1000    Data for key 1000

    2000    Data for key 2000

    (2 rows affected)

    -------------------------------

     

     

    Then, I queried test table with:

    1) DG4ODBC 11.2.0.2 + IBM-branded DataDirect ODBC driver,

    2) DG4MSQL 11.2.0.2 and

    3) DG4MSQL 11.2.0.3

     

    ---------------------------------

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

    With the Partitioning and Automatic Storage Management options

    SQL> select * from test_mssql@imos;

          PKEY DATA

    ========== ====================

          1000 Data for key 1000

          2000 Data for key 2000

    SQL> select * from test_mssql@imosprod;

          PKEY DATA

    ========== ====================

          1000 Data for key 1000

          2000 Data for key 2000

    SQL> select * from test_mssql@imosprodnew;

    select * from test_mssql@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

    ----------------------

     

    Seems to be a change in internal logic of DG4MSQL in version 11.2.0.3 to me.

  • 11. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated

    Really odd and I think there is a library issue. Could you please provide me a truss file that shows the dg4msql process being loaded?

    1. get the pid of the gateway listener (ps -ef|grep tns) and check out the process id of the gateway listener

    2. truss -fae -o dg4msql.log -p <PID of the gateway listener> &

    3. now open again SQL*Plus and connect using the gateway database link

    4. After you got the error exit from SQL*Plus, kill the truss process and there should be now a dg4msql.log file in the directory where you started the truss command => upload it again to the Dropbox and I check it out.

    - Klaus

  • 12. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated

    OK, I did a truss of listener serving DG4MSQL 11.2.0.3, log file here: https://www.dropbox.com/s/rgsf2p2xpv8v8ck/dg4msql.log

     

    In the SQL*plus I issued 3 statements (1 SELECT, 1 describe then again 1 SELECT).

  • 13. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    kgronau Guru
    Currently Being Moderated

    The gateway get's confused with your odbc.ini setting.

    898338:    62390325:  ODBCINI=/opt/IBM/WSII/odbc/odbc.ini

    ...

    5898338:    62390325: kopen("/opt/IBM/WSII/odbc/odbc.ini", O_RDONLY) = 15

     

     

    As a quick test before going into details (unsetting ODBCINI before starting gateway listener), could you please rename the odbc.ini and then test the gateway connection. Does it work when you have renamed the file "/opt/IBM/WSII/odbc/odbc.ini"?

  • 14. Re: DG4MSQL version 11.2.0.3.0, any query results in 'got native error 1007'
    ultradumb Newbie
    Currently Being Moderated

    You are absolutely right. It was ODBCINI environment variable  pointing to from IBM DataDirect drivers INI file. I blindly copied .profile with all environmant variables to the new Oracle Home owner.

     

    I have checked various queries from Oracle 11.2.0.2 and 9.2.0.8 -- everything seems to be fine now. I believe this issue is worth mentioning in a FAQ for Heterogenous Connectivity, as it is not obvious that DG4MSQL may use ODBC environment.

     

    Thank you very much indeed, issue solved!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points