This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 10, 2013 12:46 AM by kgronau RSS

Error while accessing DBlink to mysql

user580543 Newbie
Currently Being Moderated
Getting following error (trace file content) when querying suing the DB link (select * from "DeviceWindows_Devices"@monolith2.us.oracle.com;)

table: DeviceWindows_Devices
Entered hgopcda at 2012/11/15-18:56:59
Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
Entered hgopcda at 2012/11/15-18:56:59
Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
The hoada for table DeviceWindows_Devices follows...
hgodtab, line 651: Printing hoada @ 0x281a100
MAX:2, ACTUAL:2, BRC:1, WHT=6 (TABLE_DESCRIBE)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
4 INTEGER N 4 4 0/ 0 0 0 0 WindowID
4 INTEGER N 4 4 0/ 0 0 0 0 DeviceID
Exiting hgodtab, rc=0 at 2012/11/15-18:56:59
Entered hgodafr, cursor id 0 at 2012/11/15-18:56:59
Exiting hgodafr, rc=0 at 2012/11/15-18:56:59
Entered hgopars, cursor id 1 at 2012/11/15-18:56:59
type:0
SQL text from hgopars, id=1, len=60 ...
00: 53454C45 43542041 312E5769 6E646F77 [SELECT A1.Window]
10: 49442C41 312E4465 76696365 49442046 [ID,A1.DeviceID F]
20: 524F4D20 44657669 63655769 6E646F77 [ROM DeviceWindow]
30: 735F4465 76696365 73204131 [s_Devices A1]
Exiting hgopars, rc=0 at 2012/11/15-18:56:59
Entered hgoopen, cursor id 1 at 2012/11/15-18:56:59
hgoopen, line 83: NO hoada to print
Exiting hgoopen, rc=0 at 2012/11/15-18:56:59
Entered hgodscr, cursor id 1 at 2012/11/15-18:56:59
Entered hgopcda at 2012/11/15-18:56:59
Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
Entered hgopcda at 2012/11/15-18:56:59
Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
Entered hgopoer at 2012/11/15-18:56:59
hgopoer, line 159: got native error 0 and sqlstate HY092; message follows...
[unixODBC][Driver Manager]Invalid attribute/option identifier
Exiting hgopoer, rc=0 at 2012/11/15-18:56:59
hgodscr, line 456: calling SQLSetStmtAttr got sqlstate HY092
hgodscr, line 506: NO hoada to print
Exiting hgodscr, rc=28500 at 2012/11/15-18:56:59 with error ptr FILE:hgodscr.c LINE:456 FUNCTION:hgodscr() ID:Set array fetch size


Driver : ODBC 5.2(w) Driver
Oracle Database: 11.1.0.7
Mysql Database: 5.5.20

Able to connect from isql and select commands also works fine from there

-bash-3.2$ isql -v monolith_itasmon
---------------------------------------
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
---------------------------------------

Please help in resolving this, thanks in advance.

Thanks,
Vani

Edited by: user580543 on Nov 16, 2012 2:10 AM
  • 1. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    There were already a couple of people claiming issues with the MySQL ODBC driver 5.2.
    There seem to be 2 issues:
    hgopoer, line 159: got native error 0 and sqlstate HY092; message follows...
    [unixODBC][Driver Manager]Invalid attribute/option identifier
    Exiting hgopoer, rc=0 at 2012/11/15-18:56:59
    hgodscr, line 456: calling SQLSetStmtAttr got sqlstate HY092

    Which might be a unxiODBC Driver Manager issue and
    Exiting hgodscr, rc=28500 at 2012/11/15-18:56:59 with error ptr FILE:hgodscr.c LINE:456 FUNCTION:hgodscr() ID:Set array fetch size
    which might be solved by disabling BULK fetching by setting HS_FDS_FETCH_ROWS=1 in the gateway init file.


    Could you please provide the exact version of your ODBC driver you are using on which platform and also the UnixODBC driver version you are using?
    Also please post the odbc.ini file and the gateway init file.
  • 2. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    We have already set HS_FDS_FETCH_ROWS=1 in the gateway init file.

    RPM for ODBC driver : mysql-connector-odbc-5.2.2-1.rhel5.x86_64.rpm
    unixODBC version : 2.2.11
    platform : Oracle's Enterprise Linux x86_64 64bit OSCC


    -bash-3.2$ cat /home/oracle/.odbc.ini
    #====================================================================
    # .odbc.ini on wd0774.us.oracle.com : FKRONSED_DE / 08-NOV-2012
    #

    [ODBC Data Sources]
    monolith_itasmon = MySQL ODBC Driver 5.1

    [monolith_itasmon]
    Driver = /usr/lib64/libmyodbc5w.so
    #Driver = /home/bpel/libmyodbc3_r-3.51.27.so
    DATABASE = Monolith
    DESCRIPTION = MySQL ODBC 5.1.5 Connector Sample
    PORT = 3306
    SERVER = 148.87.43.53
    UID = itasmon
    PWD = ******
    #CHARSET = latin1
    CHARSET = latin1
    TRACEFILE = /tmp/myodbc-demodsn.trc
    TRACE = ON

    Thanks,
    Vani

    Edited by: user580543 on Nov 20, 2012 4:18 PM
  • 3. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    Could you generate an ODBC trace file and post it?
  • 4. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Please find the trace file



    Oracle Corporation --- MONDAY NOV 19 2012 17:47:11.399


    Heterogeneous Agent Release
    11.1.0.7.0




    Oracle Corporation --- MONDAY NOV 19 2012 17:47:11.349

    Version 11.1.0.7.0

    Entered hgogprd
    HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
    Entered hgosdip
    setting HS_OPEN_CURSORS to default of 50
    setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
    setting HS_FDS_RECOVERY_PWD to default value
    setting HS_FDS_TRANSACTION_LOG to default of "HS_TRANSACTION_LOG"
    setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
    setting HS_NLS_NCHAR to default of "AL32UTF8"
    setting HS_FDS_TIMESTAMP_AS_DATE to default of "TRUE"
    setting HS_RPC_FETCH_REBLOCKING to default of "ON"
    HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
    setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
    setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
    setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
    setting HS_FDS_MAP_NCHAR to default of "TRUE"
    setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
    setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
    setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
    setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
    setting HS_FDS_QUERY_DRIVER to default of "TRUE"
    HOSGIP returned value of "FALSE" for HS_FDS_SUPPORT_STATISTICS
    HOSGIP returned value of "`" for HS_FDS_QUOTE_IDENTIFIER
    setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics"
    Exiting hgosdip, rc=0
    ORACLE_SID is "monolith"
    Product-Info:
    Port Rls/Upd:7/0 PrdStat:0
    Agent:Oracle Database Gateway for ODBC
    Facility:hsa
    Class:ODBC, ClassVsn:11.1.0.7.0_0006, Instance:monolith
    Exiting hgogprd, rc=0
    Entered hgoinit
    HOCXU_COMP_CSET=1
    HOCXU_DRV_CSET=31
    HOCXU_DRV_NCHAR=873
    HOCXU_DB_CSET=873
    HOCXU_SEM_VER=110000
    Entered hgolofn at 2012/11/19-17:47:11
    HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so"
    Entered hgolofns at 2012/11/19-17:47:11
    symbol_peflctx=0x8be082a0
    hoaerr:0
    Exiting hgolofns at 2012/11/19-17:47:11
    Entered hgolofns at 2012/11/19-17:47:11
    symbol_peflctx=0x8be08330
    hoaerr:0
    Exiting hgolofns at 2012/11/19-17:47:11
    Entered hgolofns at 2012/11/19-17:47:11
    symbol_peflctx=0x8be08af0
    hoaerr:0
    Exiting hgolofns at 2012/11/19-17:47:11
    Entered hgolofns at 2012/11/19-17:47:11
    symbol_peflctx=0x8be09d60
    hoaerr:0
    Exiting hgolofns at 2012/11/19-17:47:11
    Entered hgolofns at 2012/11/19-17:47:11
    symbol_peflctx=0x8be117d0
    hoaerr:0
    Exiting hgolofns at 2012/11/19-17:47:11
    Entered hgolofns at 2012/11/19-17:47:11
    symbol_peflctx=0x8be11c70
    ..................................
    .....................................#removed redundant logs#
    .........................................
    Exiting hgolofns at 2012/11/19-17:47:11
    Exiting hgolofn, rc=0 at 2012/11/19-17:47:11
    HOSGIP for "HS_OPEN_CURSORS" returned "50"
    HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
    HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
    HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
    Exiting hgoinit, rc=0 at 2012/11/19-17:47:11
    Entered hgolgon at 2012/11/19-17:47:11
    reco:0, name:itasmon, tflag:0
    Entered hgosuec at 2012/11/19-17:47:11
    Exiting hgosuec, rc=0 at 2012/11/19-17:47:11
    HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
    HOSGIP for "HS_FDS_TRANSACTION_LOG" returned ""HS_TRANSACTION_LOG""
    HOSGIP for "HS_FDS_TIMESTAMP_AS_DATE" returned "TRUE"
    HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
    HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
    HOSGIP for "HS_FDS_RESULT_SET_SUPPORT" returned "FALSE"
    HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
    HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
    using itasmon as default value for "HS_FDS_DEFAULT_OWNER"
    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
    Entered hgocont at 2012/11/19-17:47:11
    HS_FDS_CONNECT_INFO = "monolith_itasmon"
    RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
    Entered hgogenconstr at 2012/11/19-17:47:11
    dsn:monolith_itasmon, name:itasmon
    optn:
    ##>Connect Parameters (len=45)<##
    ## DSN=monolith_itasmon;
    #! UID=itasmon;
    #! PWD=*
    Exiting hgogenconstr, rc=0 at 2012/11/19-17:47:11
    DriverName:libmyod, DriverVer:05.02
    DBMS Name:My, DBMS Version:5.5.20-enterprise-co
    Exiting hgocont, rc=0 at 2012/11/19-17:47:11
    SQLGetInfo returns for SQL_CATALOG_NAME
    Exiting hgolgon, rc=0 at 2012/11/19-17:47:11
    Entered hgoulcp at 2012/11/19-17:47:11
    Entered hgowlst at 2012/11/19-17:47:11
    Exiting hgowlst, rc=0 at 2012/11/19-17:47:11
    HOSGIP returned value of "`" for HS_FDS_QUOTE_IDENTIFIER
    SQLGetInfo returns for SQL_IDENTIFIER_QUOTE_CHAR
    SQLGetInfo returns for SQL_COLUMN_ALIAS
    3 instance capabilities will be uploaded
    capno:1989, context:0x00000000, add-info: 0
    capno:1991, context:0x00000000, add-info: 0
    capno:1992, context:0x00000000, add-info: 0
    Exiting hgoulcp, rc=0 at 2012/11/19-17:47:11
    Entered hgouldt at 2012/11/19-17:47:12
    0 instance DD translations were uploaded
    Exiting hgouldt, rc=0 at 2012/11/19-17:47:12
    Entered hgobegn at 2012/11/19-17:47:12
    tflag:0 , initial:1
    hoi:0x7340dea8, ttid (len 43) is ...
    00: 49544153 52442E55 532E4F52 41434C45 [ITASRD.US.ORACLE]
    10: 2E434F4D 2E386233 64316335 622E3132 [.COM.8b3d1c5b.12]
    20: 2E32312E 33313438 393236 [.21.3148926]
    tbid (len 41) is ...
    00: 49544153 52442E55 532E4F52 41434C45 [ITASRD.US.ORACLE]
    10: 2E434F4D 5B31322E 32312E33 31343839 [.COM[12.21.31489]
    20: 32365D5B 312E3230 5D [26][1.20]]
    TXN Capable:3, Isolation Option:0xf
    Exiting hgobegn, rc=0 at 2012/11/19-17:47:12
    Entered hgodtab at 2012/11/19-17:47:12
    count:1
    table: DeviceWindows_Devices
    Entered hgopdsc at 2012/11/19-17:47:12
    Describing procedure itasmon.DeviceWindows_Devices
    Output hoada
    hgopdsc, line 1298: NO hoada to print
    Exiting hgopdsc, rc=942 at 2012/11/19-17:47:12
    The hoada for table DeviceWindows_Devices follows...
    hgodtab, line 651: NO hoada to print
    Exiting hgodtab, rc=0 at 2012/11/19-17:47:12
    Entered hgopars, cursor id 1 at 2012/11/19-17:47:12
    type:0
    SQL text from hgopars, id=1, len=36 ...
    00: 53454C45 4354202A 2046524F 4D204465 [SELECT * FROM De]
    10: 76696365 57696E64 6F77735F 44657669 [viceWindows_Devi]
    20: 63657320 [ces ]
    Exiting hgopars, rc=0 at 2012/11/19-17:47:12
    Entered hgoopen, cursor id 1 at 2012/11/19-17:47:12
    hgoopen, line 83: NO hoada to print
    Exiting hgoopen, rc=0 at 2012/11/19-17:47:12
    Entered hgodscr, cursor id 1 at 2012/11/19-17:47:12
    Entered hgopcda at 2012/11/19-17:47:12
    Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:12
    Entered hgopcda at 2012/11/19-17:47:12
    Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:12
    Entered hgopoer at 2012/11/19-17:47:12
    hgopoer, line 159: got native error 0 and sqlstate HY092; message follows...
    [unixODBC][Driver Manager]Invalid attribute/option identifier
    Exiting hgopoer, rc=0 at 2012/11/19-17:47:12
    hgodscr, line 456: calling SQLSetStmtAttr got sqlstate HY092
    hgodscr, line 506: NO hoada to print
    Exiting hgodscr, rc=28500 at 2012/11/19-17:47:12 with error ptr FILE:hgodscr.c LINE:456 FUNCTION:hgodscr() ID:Set array fetch size
    Entered hgodtab at 2012/11/19-17:47:13
    count:1
    table: DeviceWindows_Devices
    Entered hgopdsc at 2012/11/19-17:47:13
    Describing procedure itasmon.DeviceWindows_Devices
    Output hoada
    hgopdsc, line 1298: NO hoada to print
    Exiting hgopdsc, rc=942 at 2012/11/19-17:47:13
    The hoada for table DeviceWindows_Devices follows...
    hgodtab, line 651: NO hoada to print
    Exiting hgodtab, rc=0 at 2012/11/19-17:47:13
    Entered hgoclse, cursor id 1 at 2012/11/19-17:47:13
    Exiting hgoclse, rc=0 at 2012/11/19-17:47:13
    Entered hgopars, cursor id 1 at 2012/11/19-17:47:13
    type:0
    SQL text from hgopars, id=1, len=36 ...
    00: 53454C45 4354202A 2046524F 4D204465 [SELECT * FROM De]
    10: 76696365 57696E64 6F77735F 44657669 [viceWindows_Devi]
    20: 63657320 [ces ]
    Exiting hgopars, rc=0 at 2012/11/19-17:47:13
    Entered hgoopen, cursor id 1 at 2012/11/19-17:47:13
    hgoopen, line 83: NO hoada to print
    Exiting hgoopen, rc=0 at 2012/11/19-17:47:13
    Entered hgodscr, cursor id 1 at 2012/11/19-17:47:13
    Entered hgopcda at 2012/11/19-17:47:13
    Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:13
    Entered hgopcda at 2012/11/19-17:47:13
    Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:13
    Entered hgopoer at 2012/11/19-17:47:13
    hgopoer, line 159: got native error 0 and sqlstate HY092; message follows...
    [unixODBC][Driver Manager]Invalid attribute/option identifier
    Exiting hgopoer, rc=0 at 2012/11/19-17:47:13
    hgodscr, line 456: calling SQLSetStmtAttr got sqlstate HY092
    hgodscr, line 506: NO hoada to print
    Exiting hgodscr, rc=28500 at 2012/11/19-17:47:13 with error ptr FILE:hgodscr.c LINE:456 FUNCTION:hgodscr() ID:Set array fetch size
    Entered hgodtab at 2012/11/19-17:47:20
    count:1
    table: DeviceWindows_Devices
    Entered hgopcda at 2012/11/19-17:47:20
    Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:20
    Entered hgopcda at 2012/11/19-17:47:20
    Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:20
    The hoada for table DeviceWindows_Devices follows...

    hgodtab, line 651: Printing hoada @ 0x1854fa98
    MAX:2, ACTUAL:2, BRC:1, WHT=6 (TABLE_DESCRIBE)
    DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
    4 INTEGER N 4 4 0/ 0 0 0 0 WindowID
    4 INTEGER N 4 4 0/ 0 0 0 0 DeviceID
    Exiting hgodtab, rc=0 at 2012/11/19-17:47:20
    Entered hgodafr, cursor id 0 at 2012/11/19-17:47:20
    Exiting hgodafr, rc=0 at 2012/11/19-17:47:20
    Entered hgoclse, cursor id 1 at 2012/11/19-17:47:20
    Exiting hgoclse, rc=0 at 2012/11/19-17:47:20
    Entered hgopars, cursor id 1 at 2012/11/19-17:47:20
    type:0
    SQL text from hgopars, id=1, len=60 ...
    00: 53454C45 43542041 312E5769 6E646F77 [SELECT A1.Window]
    10: 49442C41 312E4465 76696365 49442046 [ID,A1.DeviceID F]
    20: 524F4D20 44657669 63655769 6E646F77 [ROM DeviceWindow]
    30: 735F4465 76696365 73204131 [s_Devices A1]
    Exiting hgopars, rc=0 at 2012/11/19-17:47:21
    Entered hgoopen, cursor id 1 at 2012/11/19-17:47:21
    hgoopen, line 83: NO hoada to print
    Exiting hgoopen, rc=0 at 2012/11/19-17:47:21
    Entered hgodscr, cursor id 1 at 2012/11/19-17:47:21
    Entered hgopcda at 2012/11/19-17:47:21
    Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:21
    Entered hgopcda at 2012/11/19-17:47:21
    Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/11/19-17:47:21
    Entered hgopoer at 2012/11/19-17:47:21
    hgopoer, line 159: got native error 0 and sqlstate HY092; message follows...
    [unixODBC][Driver Manager]Invalid attribute/option identifier
    Exiting hgopoer, rc=0 at 2012/11/19-17:47:21
    hgodscr, line 456: calling SQLSetStmtAttr got sqlstate HY092
    hgodscr, line 506: NO hoada to print
    Exiting hgodscr, rc=28500 at 2012/11/19-17:47:21 with error ptr FILE:hgodscr.c LINE:456 FUNCTION:hgodscr() ID:Set array fetch size


    Thanks,
    Vani
  • 5. Re: Error while accessing DBlink to mysql
    mkirtley-Oracle Expert
    Currently Being Moderated
    Vani,
    Thanks for the DG4ODBC trace but what we also need to see is an actual ODBC trace so we can see the information being passed at the ODBC level. The HY092 error is coming from ODBC itself.

    Regards,
    Mike
  • 6. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Hi Mike,
    I hope you are asking for the trace file that was mentioned in .odbc.ini file as follows

    TRACEFILE = /tmp/myodbc-demodsn.trc
    TRACE = ON

    But I could not find any trace file under /tmp

    Please suggest.

    Thanks,
    Vani
  • 7. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    when you're using a unixODBC driver manager, then you need to enable ODBC tracing in the odbcinst.ini file. If you do not know which odbcinst.ini file your odbc driver is using, you could use strace, truss or tusc (depends on the Unix OS you're using) to trace the ODBC connection and to see where it looks for a odbcinst.ini file
  • 8. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Hi ,
    Sorry for the delay.

    Please find the trace file.

    Thanks,
    Vani

    [ODBC][26106][__handles.c][444]
              Exit:[SQL_SUCCESS]
                   Environment = 0x532c160
    [ODBC][26106][SQLSetEnvAttr.c][182]
              Entry:
                   Environment = 0x532c160
                   Attribute = SQL_ATTR_ODBC_VERSION
                   Value = 0x3
                   StrLen = -6
    [ODBC][26106][SQLSetEnvAttr.c][349]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLAllocHandle.c][345]
              Entry:
                   Handle Type = 2
                   Input Handle = 0x532c160
    [ODBC][26106][SQLAllocHandle.c][463]
              Exit:[SQL_SUCCESS]
                   Output Handle = 0x5361780
    [ODBC][26106][SQLSetConnectAttr.c][318]
              Entry:
                   Connection = 0x5361780
                   Attribute = SQL_ATTR_AUTOCOMMIT
                   Value = (nil)
                   StrLen = -5
    [ODBC][26106][SQLSetConnectAttr.c][500]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLDriverConnect.c][678]
              Entry:
                   Connection = 0x5361780
                   Window Hdl = (nil)
                   Str In = [DSN=MONOLITH_ITASMON;UID=itasmon;PWD=********][length = 45]
                   Str Out = 0x5363848
                   Str Out Max = 1024
                   Str Out Ptr = 0x7fffe146fe44
                   Completion = 0
              UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

    [ODBC][26106][SQLDriverConnect.c][1487]
              Exit:[SQL_SUCCESS]
                   Connection Out [[DSN=MONOLITH_ITASMON;UID=itasmon;PWD=********][length = 45 (SQL_NTS)]]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_DRIVER_NAME (6)
                   Info Value = 0x7fffe146fb20
                   Buffer Length = 512
                   StrLen = 0x7fffe146fe48
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_DRIVER_VER (7)
                   Info Value = 0x7fffe146fb20
                   Buffer Length = 512
                   StrLen = 0x7fffe146fe48
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_DBMS_NAME (17)
                   Info Value = 0x7fffe146fb20
                   Buffer Length = 512
                   StrLen = 0x7fffe146fe48
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_DBMS_VER (18)
                   Info Value = 0x7fffe146fb20
                   Buffer Length = 512
                   StrLen = 0x7fffe146fe48
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_CATALOG_NAME (10003)
                   Info Value = 0x7fffe146fe90
                   Buffer Length = 512
                   StrLen = 0x7fffe1470124
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_IDENTIFIER_QUOTE_CHAR (29)
                   Info Value = 0x7fffe146fd60
                   Buffer Length = 512
                   StrLen = 0x7fffe147021c
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_COLUMN_ALIAS (87)
                   Info Value = 0x7fffe146fd60
                   Buffer Length = 512
                   StrLen = 0x7fffe147021c
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    -------------------------------
    -------------------------------
    Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_NO_DATA]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_INTEGER
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_SMALLINT
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_NO_DATA]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_SMALLINT
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_VARBINARY
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_NO_DATA]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_BIGINT
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_NO_DATA]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_BIGINT
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_TINYINT
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_NO_DATA]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_TINYINT
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_LONGVARCHAR
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetTypeInfo.c][164]
              Entry:
                   Statement = 0x538ae20
                   Data Type = SQL_LONGVARBINARY
    [ODBC][26106][SQLGetTypeInfo.c][314]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 2
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLEndTran.c][315]
              Entry:
                   Connection = 0x5361780
                   Completion Type = 0
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_CURSOR_COMMIT_BEHAVIOR (23)
                   Info Value = 0x7fffe14700de
                   Buffer Length = 8
                   StrLen = 0x7fffe14700dc
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLEndTran.c][488]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_TXN_CAPABLE (46)
                   Info Value = 0x7fffe1470274
                   Buffer Length = 2
                   StrLen = 0x7fffe1470278
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLGetInfo.c][214]
              Entry:
                   Connection = 0x5361780
                   Info Type = SQL_TXN_ISOLATION_OPTION (72)
                   Info Value = 0x7fffe1470270
                   Buffer Length = 4
                   StrLen = 0x7fffe1470278
    [ODBC][26106][SQLGetInfo.c][528]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLSetConnectAttr.c][318]
              Entry:
                   Connection = 0x5361780
                   Attribute = SQL_ATTR_TXN_ISOLATION
                   Value = 0x2
                   StrLen = -5
    [ODBC][26106][SQLSetConnectAttr.c][671]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeHandle.c][365]
              Entry:
                   Handle Type = 3
                   Input Handle = 0x538ae20
    [ODBC][26106][SQLFreeHandle.c][462]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLAllocHandle.c][510]
              Entry:
                   Handle Type = 3
                   Input Handle = 0x5361780
    [ODBC][26106][SQLAllocHandle.c][872]
              Exit:[SQL_SUCCESS]
                   Output Handle = 0x538ae20
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 4
                   Target Type = 1 SQL_CHAR
                   Target Value = 0x7fffe1470028
                   Buffer Length = 124
                   StrLen Or Ind = 0x7fffe1470110
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 5
                   Target Type = -15 SQL_C_SSHORT
                   Target Value = 0x7fffe14701c0
                   Buffer Length = 0
                   StrLen Or Ind = (nil)
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 6
                   Target Type = 1 SQL_CHAR
                   Target Value = 0x7fffe146ffb0
                   Buffer Length = 120
                   StrLen Or Ind = 0x7fffe1470108
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 7
                   Target Type = -16 SQL_C_SLONG
                   Target Value = 0x7fffe14701a8
                   Buffer Length = 0
                   StrLen Or Ind = 0x7fffe1470130
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 9
                   Target Type = -15 SQL_C_SSHORT
                   Target Value = 0x7fffe14701cc
                   Buffer Length = 0
                   StrLen Or Ind = 0x7fffe1470128
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 10
                   Target Type = -15 SQL_C_SSHORT
                   Target Value = 0x7fffe14701c4
                   Buffer Length = 0
                   StrLen Or Ind = 0x7fffe1470120
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 11
                   Target Type = -15 SQL_C_SSHORT
                   Target Value = 0x7fffe14701c8
                   Buffer Length = 0
                   StrLen Or Ind = (nil)
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLBindCol.c][165]
              Entry:
                   Statement = 0x538ae20
                   Column Number = 16
                   Target Type = -16 SQL_C_SLONG
                   Target Value = 0x7fffe14701a4
                   Buffer Length = 0
                   StrLen Or Ind = 0x7fffe1470118
    [ODBC][26106][SQLBindCol.c][251]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLColumns.c][208]
              Entry:
                   Statement = 0x538ae20
                   Catalog Name = [NULL]
                   Schema Name = [itasmon][length = 7]
                   Table Name = [DeviceWindows_Devices][length = 21]
                   Column Type = [NULL]
    [ODBC][26106][SQLColumns.c][405]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFetch.c][158]
              Entry:
                   Statement = 0x538ae20
    [ODBC][26106][SQLFetch.c][340]
              Exit:[SQL_NO_DATA]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 0
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLFreeStmt.c][140]
              Entry:
                   Statement = 0x538ae20
                   Option = 2
    [ODBC][26106][SQLFreeStmt.c][246]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLAllocHandle.c][510]
              Entry:
                   Handle Type = 3
                   Input Handle = 0x5361780
    [ODBC][26106][SQLAllocHandle.c][872]
              Exit:[SQL_SUCCESS]
                   Output Handle = 0x53bdd30
    [ODBC][26106][SQLPrepare.c][189]
              Entry:
                   Statement = 0x53bdd30
                   SQL = [SELECT A1.WindowID,A1.DeviceID FROM DeviceWindows_Devices A1][length = 60]
    [ODBC][26106][SQLPrepare.c][364]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLNumResultCols.c][149]
              Entry:
                   Statement = 0x53bdd30
                   Column Count = 0x532c880
    [ODBC][26106][SQLNumResultCols.c][234]
              Exit:[SQL_SUCCESS]
                   Count = 0x532c880 -> 2
    [ODBC][26106][SQLExecute.c][183]
              Entry:
                   Statement = 0x53bdd30
    [ODBC][26106][SQLExecute.c][344]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLDescribeCol.c][231]
              Entry:
                   Statement = 0x53bdd30
                   Column Number = 1
                   Column Name = 0x7fffe146ff00
                   Buffer Length = 30
                   Name Length = 0x7fffe1470044
                   Data Type = 0x7fffe1470040
                   Column Size = 0x7fffe146ffe8
                   Decimal Digits = 0x7fffe147003c
                   Nullable = 0x7fffe1470038
    [ODBC][26106][SQLDescribeCol.c][474]
              Exit:[SQL_SUCCESS]
                   Column Name = [WindowID]
                   Data Type = 0x7fffe1470040 -> 4
                   Column Size = 0x7fffe146ffe8 -> 10
                   Decimal Digits = 0x7fffe147003c -> 0
                   Nullable = 0x7fffe1470038 -> 0
    [ODBC][26106][SQLColAttribute.c][277]
              Entry:
                   Statement = 0x53bdd30
                   Column Number = 1
                   Field Identifier = SQL_DESC_UNSIGNED
                   Character Attr = (nil)
                   Buffer Length = 0
                   String Length = (nil)
                   Numeric Attribute = 0x7fffe146fff0
    [ODBC][26106][SQLColAttribute.c][648]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLDescribeCol.c][231]
              Entry:
                   Statement = 0x53bdd30
                   Column Number = 2
                   Column Name = 0x7fffe146ff00
                   Buffer Length = 30
                   Name Length = 0x7fffe1470044
                   Data Type = 0x7fffe1470040
                   Column Size = 0x7fffe146ffe8
                   Decimal Digits = 0x7fffe147003c
                   Nullable = 0x7fffe1470038
    [ODBC][26106][SQLDescribeCol.c][474]
              Exit:[SQL_SUCCESS]
                   Column Name = [DeviceID]
                   Data Type = 0x7fffe1470040 -> 4
                   Column Size = 0x7fffe146ffe8 -> 10
                   Decimal Digits = 0x7fffe147003c -> 0
                   Nullable = 0x7fffe1470038 -> 0
    [ODBC][26106][SQLColAttribute.c][277]
              Entry:
                   Statement = 0x53bdd30
                   Column Number = 2
                   Field Identifier = SQL_DESC_UNSIGNED
                   Character Attr = (nil)
                   Buffer Length = 0
                   String Length = (nil)
                   Numeric Attribute = 0x7fffe146fff0
    [ODBC][26106][SQLColAttribute.c][648]
              Exit:[SQL_SUCCESS]
    [ODBC][26106][SQLSetStmtAttr.c][243]
              Entry:
                   Statement = 0x53bdd30
                   Attribute = SQL_ATTR_ROW_ARRAY_SIZE
                   Value = 0x1
                   StrLen = 0
    [ODBC][26106][SQLSetStmtAttr.c][636]Error: HY092
    [ODBC][26106][SQLGetDiagRec.c][710]
              Entry:
                   Statement = 0x53bdd30
                   Rec Number = 1
                   SQLState = 0x7fffe146fe48
                   Native = 0x7fffe146fec0
                   Message Text = 0x7fffe146fc30
                   Buffer Length = 510
                   Text Len Ptr = 0x7fffe146fec4
    [ODBC][26106][SQLGetDiagRec.c][747]
              Exit:[SQL_SUCCESS]
                   SQLState = HY092
                   Native = 0x7fffe146fec0 -> 0
                   Message Text = [[unixODBC][Driver Manager]Invalid attribute/option identifier]
    [ODBC][26106][SQLGetDiagRec.c][710]
              Entry:
                   Statement = 0x53bdd30
                   Rec Number = 2
                   SQLState = 0x7fffe146fe48
                   Native = 0x7fffe146fec0
                   Message Text = 0x7fffe146fc30
                   Buffer Length = 510
                   Text Len Ptr = 0x7fffe146fec4
    [ODBC][26106][SQLGetDiagRec.c][747]
              Exit:[SQL_NO_DATA]
  • 9. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    The error is coming from the ODBC driver it misses an ODBC feature:
    Attribute = SQL_ATTR_ROW_ARRAY_SIZE
    Value = 0x1
    StrLen = 0
    [ODBC][26106][SQLSetStmtAttr.c][636]Error: HY092


    Not sure why as it is commonly implemented in the MySQL driver. The driver version is reported as DriverName:libmyod, DriverVer:05.02 and I installed the same driver which works in my Linux env. Just as a try, please unset from the gateway init file HS_FDS_FETCH_ROWS=1 and then check again.

    Edited by: kgronau on Dec 17, 2012 11:20 AM
  • 10. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Hi,
    Tried by commenting HS_FDS_FETCH_ROWS=1 in init<sid>.ora

    But no luck and same error occurs.

    Please suggest.

    Thanks,
    Vani
  • 11. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    Vani,
    the error message is coming from the ODBC Driver Manager/ODBC Driver.

    Maybe I missed that info in the provided details, but at least didn't find it anymore, so posting my question:

    Who's the ODBC Driver Manager (unixODBC?) and what's the version? To check it, please use odbcinst -j and provide the details.
    What's the full version of the MySQL ODBC driver you applied, the trace only reports: DriverName:libmyod, DriverVer:05.02

    - Klaus
  • 12. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Hi Klaus,

    Please find the details.

    -bash-3.2$ odbcinst -j
    unixODBC 2.2.11
    DRIVERS............: /etc/odbcinst.ini
    SYSTEM DATA SOURCES: /etc/odbc.ini
    USER DATA SOURCES..: /home/oracle/.odbc.ini

    RPM for ODBC driver : mysql-connector-odbc-5.2.2-1.rhel5.x86_64.rpm

    Please let me know for any further details.

    Thanks,
    Vani
  • 13. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    Hi Vani,
    the Driver Manager is outdated. This old version had very limited 64bit support, so I strongly recommend to update to 2.3.x release.

    Regarding the MySQL ODBC driver I'm using the same release and I'm able to select from the tables. Feel free to provide me the MySQL table description and I can also verify it with your particular table.

    - Klaus
  • 14. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Hi

    We shall upgrade Driver Manager to 2.3.x release and get back to you.

    Following is the description of the table

    WindowID int(10)
    DeviceID int(10)

    Thanks,
    Vani
1 2 Previous Next

Legend

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