9 Replies Latest reply: Jul 10, 2012 4:01 AM by Kgronau-Oracle RSS

    MySQL table description(the way the table is defined at the MySQL Server)

    user1888509
      Hi,

      I have connected oracle DB to mySQL DB, but when i tried to select record, i got below message.

      SQL> select * from nama@link2mysqltest;
      ERROR:
      ORA-28528: Heterogeneous Services datatype conversion error
      [MySQL][ODBC 5.1 Driver][mysqld-5.1.41] {01004}
      ORA-02063: preceding 2 lines from LINK2MYSQLTEST

      Appreciate for your help.

      Thanks and regards,
      Iwanto
        • 1. Re: MySQL table description(the way the table is defined at the MySQL Server)
          Kgronau-Oracle
          Can you please post the MySQL table description?
          • 2. Re: MySQL table description(the way the table is defined at the MySQL Server)
            user1888509
            Below is the table structure.


            Field TYPE
            NAMA varchar(70)
            no_kontrak varchar(20)
            • 3. Re: MySQL table description(the way the table is defined at the MySQL Server)
              Kgronau-Oracle
              varchar is commonly not a problem. What's the character set of the MySQL database and your Oracle db?
              • 4. Re: MySQL table description(the way the table is defined at the MySQL Server)
                user1888509
                mySQL Char set = latin1
                Oracle NLS_CHARACTERSET = WE8MSWIN1252
                • 5. Re: MySQL table description(the way the table is defined at the MySQL Server)
                  Kgronau-Oracle
                  still no idea why it claims about data type issue.
                  Please add to the gateway init file:
                  HS_LANGUAGE=american_america.we8iso8859p1
                  HS_NLS_NCHAR=UCS2

                  Then check again.

                  Edited by: kgronau on Jul 6, 2012 10:19 AM
                  from the previous thread the environment for DG4ODBC is Windows 32bit
                  • 6. Re: MySQL table description(the way the table is defined at the MySQL Server)
                    user1888509
                    Hi,

                    I have changed and i still got the same error.

                    Any other can help ?


                    Thanks and regards,
                    Iwanto
                    • 7. Re: MySQL table description(the way the table is defined at the MySQL Server)
                      Kgronau-Oracle
                      Please set in your gateway init file HS_FDS_TRACE_LEVEL=255, then start a new SQL*Plus session and selet from your table.
                      Once you get the error, please upload the trace file which is located in the 11.2 gateway home/hs/trace.
                      • 8. Re: MySQL table description(the way the table is defined at the MySQL Server)
                        user1888509
                        Hi,

                        Below is the trace file :
                        ===================

                        Oracle Corporation --- TUESDAY JUL 10 2012 15:26:18.015


                        Heterogeneous Agent Release
                        11.2.0.1.0

                        Oracle Corporation --- TUESDAY JUL 10 2012 15:26:18.015

                        Version 11.2.0.1.0

                        Entered hgogprd
                        HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"
                        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_IDLE_TIMEOUT to default of 0
                        setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
                        setting HS_NLS_NCHAR to default of "UCS2"
                        setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
                        setting HS_FDS_DATE_MAPPING to default of "DATE"
                        setting HS_RPC_FETCH_REBLOCKING to default of "ON"
                        setting HS_FDS_FETCH_ROWS to default of "100"
                        setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
                        setting HS_FDS_RSET_RETURN_ROWCOUNT 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"
                        setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
                        HOSGIP returned value of "FALSE" for HS_FDS_QUOTE_IDENTIFIER
                        setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
                        setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
                        setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
                        Default value of 32 assumed for HS_FDS_SQLLEN_INTERPRETATION
                        setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
                        setting HS_FDS_DELAYED_OPEN to default of "TRUE"
                        setting HS_FDS_WORKAROUNDS to default of "0"
                        Exiting hgosdip, rc=0
                        ORACLE_SID is "tst"
                        Product-Info:
                        Port Rls/Upd:1/0 PrdStat:0
                        Agent:Oracle Database Gateway for ODBC
                        Facility:hsa
                        Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:tst
                        Exiting hgogprd, rc=0
                        hostmstr: 2057621504:      HOA After hoagprd
                        hostmstr: 2057621504:      HOA Before hoainit
                        Entered hgoinit
                        HOCXU_COMP_CSET=1
                        HOCXU_DRV_CSET=31
                        HOCXU_DRV_NCHAR=1000
                        HOCXU_DB_CSET=178
                        HOCXU_SEM_VER=102000
                        Entered hgolofn at 2012/07/10-15:26:18
                        Exiting hgolofn, rc=0 at 2012/07/10-15:26:18
                        HOSGIP for "HS_OPEN_CURSORS" returned "50"
                        HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
                        HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
                        HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
                        HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
                        HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
                        HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
                        HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
                        HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
                        Invalid value of 32 given for HS_FDS_SQLLEN_INTERPRETATION
                        treat_SQLLEN_as_compiled = 1
                        Exiting hgoinit, rc=0 at 2012/07/10-15:26:19
                        hostmstr: 2057621504:      HOA After hoainit
                        hostmstr: 2057621504:      HOA Before hoalgon
                        Entered hgolgon at 2012/07/10-15:26:19
                        reco:0, name:oracle, tflag:0
                        Entered hgosuec at 2012/07/10-15:26:19
                        Exiting hgosuec, rc=0 at 2012/07/10-15:26:19
                        HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
                        HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
                        HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
                        HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
                        HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
                        HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
                        HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
                        HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
                        HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
                        HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
                        using oracle as default value for "HS_FDS_DEFAULT_OWNER"
                        HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
                        Entered hgocont at 2012/07/10-15:26:19
                        HS_FDS_CONNECT_INFO = "BPKB"
                        RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
                        Entered hgogenconstr at 2012/07/10-15:26:19
                        dsn:BPKB, name:oracle
                        optn:
                        Entered hgocip at 2012/07/10-15:26:19
                        dsn:BPKB
                        Exiting hgocip, rc=0 at 2012/07/10-15:26:19
                        ##>Connect Parameters (len=30)<##
                        ## DSN=BPKB;
                        #! UID=oracle;
                        #! PWD=*
                        Exiting hgogenconstr, rc=0 at 2012/07/10-15:26:19
                        Entered hgolosf at 2012/07/10-15:26:22
                        ODBC Function-Available-Array 0xFFFE 0x01FF 0xFF00 0xFF7F 0x03FF 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
                        0x0000 0x0000 0xFE00 0x3F5F
                        Exiting hgolosf, rc=0 at 2012/07/10-15:26:22
                        DriverName:myodbc5.dll, DriverVer:05.01.0006
                        DBMS Name:MySQL, DBMS Version:5.1.41
                        Exiting hgocont, rc=0 at 2012/07/10-15:26:22
                        SQLGetInfo returns Y for SQL_CATALOG_NAME
                        SQLGetInfo returns 192 for SQL_MAX_CATALOG_NAME_LEN
                        Exiting hgolgon, rc=0 at 2012/07/10-15:26:22
                        hostmstr: 2053578752:      HOA After hoalgon
                        RPC Calling nscontrol(0), rc=0
                        hostmstr: 2053578752: RPC Before Upload Caps
                        hostmstr: 2053578752:      HOA Before hoaulcp
                        Entered hgoulcp at 2012/07/10-15:26:23
                        Entered hgowlst at 2012/07/10-15:26:23
                        Exiting hgowlst, rc=0 at 2012/07/10-15:26:23
                        SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
                        TXN Capable:3, Isolation Option:0xf
                        SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
                        SQLGetInfo returns 192 for SQL_MAX_TABLE_NAME_LEN
                        SQLGetInfo returns 192 for SQL_MAX_PROCEDURE_NAME_LEN
                        HOSGIP returned value of "FALSE" for HS_FDS_QUOTE_IDENTIFIER
                        SQLGetInfo returns Y for SQL_COLUMN_ALIAS
                        16 instance capabilities will be uploaded
                        capno:1964, context:0x00000000, add-info: 0
                        capno:1989, context:0x00000000, add-info: 0
                        capno:1991, context:0x00000000, add-info: 0
                        capno:1992, context:0x00000000, add-info: 0
                        capno:3042, context:0x00000000, add-info: 0, translation:"42"
                        capno:3047, context:0x00000000, add-info: 0, translation:"57"
                        capno:3049, context:0x00000000, add-info: 0, translation:"59"
                        capno:3050, context:0x00000000, add-info: 0, translation:"60"
                        capno:3066, context:0x00000000, add-info: 0
                        capno:3067, context:0x00000000, add-info: 0
                        capno:3068, context:0x00000000, add-info: 0
                        capno:3069, context:0x00000000, add-info: 0
                        capno:3500, context:0x00000001, add-info: 91, translation:"42"
                        capno:3501, context:0x00000001, add-info: 93, translation:"57"
                        capno:3502, context:0x00000001, add-info: 107, translation:"59"
                        capno:3503, context:0x00000001, add-info: 110, translation:"60"
                        Exiting hgoulcp, rc=0 at 2012/07/10-15:26:29
                        hostmstr: 2053578752:      HOA After hoaulcp
                        hostmstr: 2053578752: RPC After Upload Caps
                        hostmstr: 2053578752: RPC Before Upload DDTR
                        hostmstr: 2053578752:      HOA Before hoauldt
                        Entered hgouldt at 2012/07/10-15:26:29
                        NO instance DD translations were uploaded
                        Exiting hgouldt, rc=0 at 2012/07/10-15:26:29
                        hostmstr: 2053578752:      HOA After hoauldt
                        hostmstr: 2053578752: RPC After Upload DDTR
                        hostmstr: 2053578752: RPC Before Begin Trans
                        hostmstr: 2053578752:      HOA Before hoabegn
                        Entered hgobegn at 2012/07/10-15:26:29
                        tflag:0 , initial:1
                        hoi:0x12f094, ttid (len 54) is ...
                        00: 4F52434C 2E524547 52455353 2E524442 [ORCL.REGRESS.RDB]
                        10: 4D532E44 45562E55 532E4F52 41434C45 [MS.DEV.US.ORACLE]
                        20: 2E434F4D 2E303139 34303665 342E322E [.COM.019406e4.2.]
                        30: 32322E39 3936 [22.996]
                        tbid (len 10) is ...
                        0: 02001600 E4030000 0104 [..........]
                        Exiting hgobegn, rc=0 at 2012/07/10-15:26:30
                        hostmstr: 2053578752:      HOA After hoabegn
                        hostmstr: 2053578752: RPC After Begin Trans
                        hostmstr: 2053578752: RPC Before Describe Table
                        hostmstr: 2053578752:      HOA Before hoadtab
                        Entered hgodtab at 2012/07/10-15:26:30
                        count:1
                        table: nama
                        Allocate hoada[0] @ 02616F8C
                        Entered hgopcda at 2012/07/10-15:26:30
                        Column:1(nama): dtype:-9 (WVARCHAR), prc/scl:70/0, nullbl:0, octet:70, sign:1, radix:0
                        Exiting hgopcda, rc=0 at 2012/07/10-15:26:30
                        Entered hgopcda at 2012/07/10-15:26:31
                        Column:2(no_kontrak): dtype:-9 (WVARCHAR), prc/scl:20/0, nullbl:0, octet:20, sign:1, radix:0
                        Exiting hgopcda, rc=0 at 2012/07/10-15:26:31
                        The hoada for table nama follows...
                        hgodtab, line 904: Printing hoada @ 02616F8C
                        MAX:2, ACTUAL:2, BRC:1, WHT=6 (TABLE_DESCRIBE)
                        hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR)
                        DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                        12 VARCHAR N 70 70 128/ 70 1000 0 40 nama
                        12 VARCHAR N 20 20 128/ 20 1000 0 40 no_kontrak
                        Exiting hgodtab, rc=0 at 2012/07/10-15:26:31
                        hostmstr: 2053578752:      HOA After hoadtab
                        hostmstr: 2053578752:      HOA Before hoadafr
                        Entered hgodafr, cursor id 0 at 2012/07/10-15:26:31
                        Free hoada @ 02616F8C
                        Exiting hgodafr, rc=0 at 2012/07/10-15:26:31
                        hostmstr: 2053578752:      HOA After hoadafr
                        hostmstr: 2053578752: RPC After Describe Table
                        hostmstr: 2053578752: RPC Before SQL Bundling
                        hostmstr: 2053578752:      HOA Before hoxpars
                        Entered hgopars, cursor id 1 at 2012/07/10-15:26:31
                        type:0
                        SQL text from hgopars, id=1, len=41 ...
                        00: 53454C45 43542041 312E6E61 6D612C41 [SELECT A1.nama,A]
                        10: 312E6E6F 5F6B6F6E 7472616B 2046524F [1.no_kontrak FRO]
                        20: 4D206E61 6D612041 31 [M nama A1]
                        Exiting hgopars, rc=0 at 2012/07/10-15:26:32
                        hostmstr: 2047287296:      HOA After hoxpars
                        hostmstr: 2047287296:      HOA Before hoxopen
                        Entered hgoopen, cursor id 1 at 2012/07/10-15:26:32
                        hgoopen, line 87: NO hoada to print
                        Deferred open until first fetch.
                        Exiting hgoopen, rc=0 at 2012/07/10-15:26:32
                        hostmstr: 2047287296:      HOA After hoxopen
                        hostmstr: 2047287296:      HOA Before hoxdscr
                        Entered hgodscr, cursor id 1 at 2012/07/10-15:26:32
                        Allocate hoada @ 02616F40
                        Entered hgopcda at 2012/07/10-15:26:32
                        Column:1(nama): dtype:-9 (WVARCHAR), prc/scl:70/0, nullbl:0, octet:71, sign:1, radix:0
                        Exiting hgopcda, rc=0 at 2012/07/10-15:26:32
                        Entered hgopcda at 2012/07/10-15:26:32
                        Column:2(no_kontrak): dtype:-9 (WVARCHAR), prc/scl:20/0, nullbl:0, octet:21, sign:1, radix:0
                        Exiting hgopcda, rc=0 at 2012/07/10-15:26:32
                        hgodscr, line 910: Printing hoada @ 02616F40
                        MAX:2, ACTUAL:2, BRC:100, WHT=5 (SELECT_LIST)
                        hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR)
                        DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                        12 VARCHAR N 71 71 128/ 70 1000 0 40 nama
                        12 VARCHAR N 21 21 128/ 20 1000 0 40 no_kontrak
                        Exiting hgodscr, rc=0 at 2012/07/10-15:26:32
                        hostmstr: 2047287296:      HOA After hoxdscr
                        hostmstr: 2047287296: RPC After SQL Bundling
                        hostmstr: 2047287296: RPC Before Fetch Row
                        hostmstr: 2047287296:      HOA Before hoaftch
                        Entered hgoftch, cursor id 1 at 2012/07/10-15:26:32
                        hgoftch, line 130: Printing hoada @ 02616F40
                        MAX:2, ACTUAL:2, BRC:100, WHT=5 (SELECT_LIST)
                        hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR)
                        DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                        12 VARCHAR N 71 71 128/ 70 1000 0 40 nama
                        12 VARCHAR N 21 21 128/ 20 1000 0 40 no_kontrak
                        Performing delayed open.
                        SQLBindCol: column 1, cdatatype: -8, bflsz: 74
                        SQLBindCol: column 2, cdatatype: -8, bflsz: 24
                        Entered hgopoer at 2012/07/10-15:26:33
                        hgopoer, line 233: got native error 0 and sqlstate 01004; message follows...
                        [MySQL][ODBC 5.1 Driver][mysqld-5.1.41] {01004}
                        Exiting hgopoer, rc=0 at 2012/07/10-15:26:33
                        hgoftch, line 740: calling SQLFetch got sqlstate 01004
                        SQLFetch: row: 1, column 1, bflsz: 74, bflar: 28
                        SQLFetch: row: 1, column 1, bflsz: 74, bflar: 28, (bfl: 71, mbl: 71)
                        00: 52004900 43004B00 59002000 48004500 [R.I.C.K.Y. .H.E.]
                        10: 52004D00 41005700 41004E00 [R.M.A.W.A.N.]
                        SQLFetch: row: 1, column 2, bflsz: 24, bflar: 24
                        SQLFetch: row: 1, column 2, bflsz: 24, bflar: 24, (bfl: 21, mbl: 21)
                        00: 31003000 31003000 30003000 30003000 [1.0.1.0.0.0.0.0.]
                        10: 30003300 34000000 [0.3.4...]
                        SQLFetch: row: 2, column 1, bflsz: 74, bflar: 30
                        SQLFetch: row: 2, column 1, bflsz: 74, bflar: 30, (bfl: 0, mbl: 71)
                        00: 59004100 4E005400 4F002000 42004900 [Y.A.N.T.O. .B.I.]
                        10: 4E002000 41005300 4C004900 4B00 [N. .A.S.L.I.K.]
                        SQLFetch: row: 2, column 2, bflsz: 24, bflar: 24
                        SQLFetch: row: 2, column 2, bflsz: 24, bflar: 24, (bfl: 0, mbl: 21)
                        00: 31003000 31003000 30003000 30003000 [1.0.1.0.0.0.0.0.]
                        10: 30003300 34000000 [0.3.4...]
                        SQLFetch: row: 3, column 1, bflsz: 74, bflar: 30
                        SQLFetch: row: 3, column 1, bflsz: 74, bflar: 30, (bfl: 0, mbl: 71)
                        00: 4D004900 53004100 52002000 42004900 [M.I.S.A.R. .B.I.]
                        10: 4E002000 53005500 44004500 4E00 [N. .S.U.D.E.N.]
                        SQLFetch: row: 3, column 2, bflsz: 24, bflar: 24
                        SQLFetch: row: 3, column 2, bflsz: 24, bflar: 24, (bfl: 0, mbl: 21)
                        00: 31003000 31003000 30003000 30003000 [1.0.1.0.0.0.0.0.]
                        10: 30003300 34000000 [0.3.4...]
                        SQLFetch: row: 4, column 1, bflsz: 74, bflar: 34
                        SQLFetch: row: 4, column 1, bflsz: 74, bflar: 34, (bfl: 0, mbl: 71)
                        00: 48004100 52004400 4A004100 44002000 [H.A.R.D.J.A.D. .]
                        10: 53004F00 45004D00 41004E00 54005200 [S.O.E.M.A.N.T.R.]
                        20: 4900 [I.]
                        SQLFetch: row: 4, column 2, bflsz: 24, bflar: 24
                        SQLFetch: row: 4, column 2, bflsz: 24, bflar: 24, (bfl: 0, mbl: 21)
                        00: 31003
                        .
                        . XXXX----> i deleted this because too many line repeating.
                        .
                        .

                        SQLFetch: row: 99, column 2, bflsz: 24, bflar: 24
                        SQLFetch: row: 99, column 2, bflsz: 24, bflar: 24, (bfl: 0, mbl: 21)
                        00: 31003000 34003000 30003000 30003000 [1.0.4.0.0.0.0.0.]
                        10: 30003000 31000000 [0.0.1...]
                        SQLFetch: row: 100, column 1, bflsz: 74, bflar: 40
                        SQLFetch: row: 100, column 1, bflsz: 74, bflar: 40, (bfl: 0, mbl: 71)
                        00: 44004500 42004F00 52004100 48002000 [D.E.B.O.R.A.H. .]
                        10: 59005500 53005400 49004E00 41002000 [Y.U.S.T.I.N.A. .]
                        20: 44004500 57004900 [D.E.W.I.]
                        SQLFetch: row: 100, column 2, bflsz: 24, bflar: 24
                        SQLFetch: row: 100, column 2, bflsz: 24, bflar: 24, (bfl: 0, mbl: 21)
                        00: 31003000 31003000 30003000 30003000 [1.0.1.0.0.0.0.0.]
                        10: 30003300 30000000 [0.3.0...]
                        100 rows fetched
                        Exiting hgoftch, rc=0 at 2012/07/10-15:26:51 with error ptr FILE:hgoftch.c LINE:740 ID:Fetch resultset data
                        hostmstr: 2047287296:      HOA After hoaftch
                        hostmstr: 2047287296: RPC After Fetch Row
                        • 9. Re: MySQL table description(the way the table is defined at the MySQL Server)
                          Kgronau-Oracle
                          From the trace I see that the data is fetched and the data is retrieved as a national varchar using charset 1000 (=UCS2)
                          ...
                          Column:2(no_kontrak): dtype:-9 (WVARCHAR), prc/scl:20/0, nullbl:0, octet:21, sign:1, radix:0
                          ...
                          12 VARCHAR N 71 71 128/ 70 1000 0 40 nama
                          12 VARCHAR N 21 21 128/ 20 1000 0 40 no_kontrak
                          Exiting hgodscr, rc=0 at 2012/07/10-15:26:32


                          We also see that data is fetched in double bytes:
                          SQLFetch: row: 1, column 1, bflsz: 74, bflar: 28, (bfl: 71, mbl: 71)
                          00: 52004900 43004B00 59002000 48004500 [R.I.C.K.Y. .H.E.]
                          10: 52004D00 41005700 41004E00 [R.M.A.W.A.N.]

                          (00 byte after each letter)

                          What I'm wondering about is the ODBC error shown in the trace:
                          Entered hgopoer at 2012/07/10-15:26:33
                          hgopoer, line 233: got native error 0 and sqlstate 01004; message follows...
                          [MySQL][ODBC 5.1 Driver][mysqld-5.1.41] {01004}


                          There's a MySQL 5.1.11 ODBC driver (you're currently using DriverName:myodbc5.dll, DriverVer:05.01.0006) - could you please update the driver to see if we get rid of the ODBC error?