1 2 Previous Next 19 Replies Latest reply: Jan 10, 2013 2:46 AM by Kgronau-Oracle RSS

    Error while accessing DBlink to mysql

    user580543
      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-Oracle
          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
            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-Oracle
              Could you generate an ODBC trace file and post it?
              • 4. Re: Error while accessing DBlink to mysql
                user580543
                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
                  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
                    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-Oracle
                      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
                        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-Oracle
                          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
                            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-Oracle
                              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
                                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-Oracle
                                  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
                                    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