1 2 Previous Next 25 Replies Latest reply: Feb 19, 2013 2:22 AM by User353235 RSS

    [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

    User353235
      Hi,

      I have installed ODBC driver to connect to MS SQL databas (2008) from oracle database 11gr1 on linux 64-bit. I have downloaded and installed

      as per the instructions on microsoft website:

      microsoft.com/en-us/download/details.aspx?id=28160

      Afte this i have configured the DG4ODBC following note ID 561033.1. Below are the details of the files i have edited to configure.

      Listener.ora:
      ---------------

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME=DG4ODBC)
      (ORACLE_HOME=/u01/oracle/fakieh/db/tech_st/11.1.0)
      (ENV="LD_LIBRARY_PATH=/usr/lib64:/u01/oracle/fakieh/db/tech_st/11.1.0/lib")
      (PROGRAM=dg4odbc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = testdb.domain.com ) (PORT = 1511))
      )
      )
      )

      tnsnames.ora:
      -------------
      DG4ODBC=
      (DESCRIPTION=
      (ADDRESS=(PROTOCOL=tcp)(HOST= testdb.domain.com )(PORT=1511))
      (CONNECT_DATA=(SID=DG4ODBC))
      (HS=OK)
      )

      initDG4ODBC.ora ($ORACLE_HOME/hs/admin)
      --------------------------------------
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO = mssql
      HS_FDS_TRACE_LEVEL = off
      HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so

      #
      # ODBC specific environment variables
      #
      set ODBCINI=/home/oracle/odbc.ini


      #
      # Environment variables required for the non-Oracle system
      #
      #set <envvar>=<value>


      odbc.ini
      --------

      [ODBC Data Sources]
      mssql=MS SQL Server

      [mssql]
      Driver=/usr/lib64/libodbc.so
      Database=FAKIH_ToTestInt
      LogonID=user
      Password=passwd
      Address=SJSQLV01.domain.com
      QuotedId=YES
      AnsiNPW=YES
      HS_FDS_SUPPORT_STATISTICS=FALSE
      [ODBC]
      IANAAppCodePage=4
      Trace=0
      UseCursorLib=0
      UseCursorLib=0



      Tnsping is successful, but when i try to connect the remote db it give me below message.

      SQL> select * from "systables"@mssqltest;
      select * from "systables"@mssqltest
      *
      ERROR at line 1:
      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
      ORA-02063: preceding 2 lines from MSSQLTEST


      please suggest how to resolve this.
        • 1. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
          Kgronau-Oracle
          What's the version of your ODBC Driver manager (/usr/lib64/libodbc.so) library - commnly "odbcinst -j" might report the correct version).
          Could you also please provide the output of "file /usr/lib64/libodbc.so"?

          Finally are you able to connect with the ODBC driver to the MS SQL Server database (for example using isql)?

          Edited by: kgronau on Dec 5, 2012 3:05 PM

          One thing I forgot:
          Have a look at the odbc.ini where you state:
          Driver=/usr/lib64/libodbc.so

          => libodbc is the ODBC Driver Manager, not the MS ODBC Driver library.
          Please check out the document from MS again (http://msdn.microsoft.com/en-US/library/hh568454.aspx) as it shows the ODBC Driver library is libsqlncli-11.0.so.<version number> like libsqlncli-11.0.so.1720.0
          • 2. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
            User353235
            Hi Kgronau,

            Thanks for your support. I have changed the driver to the actual ODBC driver location "/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0". When try to connect again, it give me new error message.
            select * from "systables"@mssqltest
            *
            ERROR at line 1:
            ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
            [unixODBC][Microsoft][SQL Server Native Client 11.0]Login timeout
            expired[unixODBC][Microsoft][SQL Server Native Client 11.0]A network-related or
            instance-specific error has occurred while establishing a connection to SQL
            Server. Server is not found or not accessible. Check if instance name is
            correct and if SQL Server is configured to allow remote connections. For more
            information see SQL Server Books Online.[unixODBC][Microsoft][SQL Server Native
            Client 11.0]TCP Provider: Error code 0x2726
            ORA-02063: preceding 2 lines from MSSQLTEST


            I can connect to remote server with remote desktop (mstsc) using port number. Also i have checked that the MS SQL server is configured to allow remote connections.

            Thank you.
            • 3. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
              Kgronau-Oracle
              As far as I know MS SQl Server ODBC driver uses the key word Server instead of Address.
              So maybe you change it to: Server=SJSQLV01.domain.com,1433 (when your SQl Server is using the 1433 port).

              If isql still times out, try to telnet to this machine and port:
              telnet SJSQLV01.domain.com 1433
              • 4. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                User353235
                Hi Kgronau,

                The isq connection was not working, it works after i copied the odbc.ini to /etc/odbc.ini.

                [oracle@testdb ~]$ isql -v mssql OracleUser p@sswd
                ---------------------------------------
                | Connected! |
                | |
                | sql-statement |
                | help [tablename] |
                | quit |
                | |
                ---------------------------------------
                SQL> select * from "emptest";
                -------------------------------------------
                | empnumber | empname | telephone |
                -------------------------------------------
                | ab1 | abc1 | 123 |
                -------------------------------------------
                SQLRowCount returns 0
                1 rows fetched



                But when i am trying to connect from sql, its giving below error:


                SQL> select * from "emptest"@mssqltest;
                select * from "emptest"@mssqltest
                *
                ERROR at line 1:
                ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
                [Microsoft][SQL Server Native Client 11.0]Connection is busy with results for
                another command
                ORA-02063: preceding 2 lines from MSSQLTEST

                After this when i am want to exit from this session (after a minute), it gives me below error.

                SQL> exit
                ERROR:
                ORA-28511: lost RPC connection to heterogeneous remote agent using
                SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
                SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdb.domain.com)(PORT=1511)
                )(CONNECT_DATA=(SID=DG4ODBC)))
                ORA-02063: preceding line from MSSQLTEST
                Process ID: 0
                Session ID: 325 Serial number: 63849


                Thank you.
                • 5. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                  Kgronau-Oracle
                  remove from the odbc.ini file the parameter HS_FDS_SUPPORT_STATISTICS=FALSE and put it into your gateway init fille. If it continues to fail, please enable gateway tracing by setting: HS_FDS_TRACE_LEVEL=255 in the gateway init file, then start a new SQL*Plus session and execute again the select.
                  the trace file is then found in $OH/hs/log.
                  • 6. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                    User353235
                    Hi Kgronau,

                    Again i received below error:

                    SQL> select * from "emptest"@mssqltest;
                    ERROR:
                    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
                    [Microsoft][SQL Server Native Client 11.0]String data, right
                    truncation[Microsoft][SQL Server Native Client 11.0]String data, right
                    truncation
                    ORA-02063: preceding 2 lines from MSSQLTEST



                    no rows selected

                    Trace file:
                    -------------


                    Oracle Corporation --- FRIDAY DEC 07 2012 16:36:01.648


                    Heterogeneous Agent Release
                    11.1.0.7.0




                    Oracle Corporation --- FRIDAY DEC 07 2012 16:36:01.648

                    Version 11.1.0.7.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_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"
                    setting HS_FDS_FETCH_ROWS to default of "100"
                    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
                    Parameter HS_FDS_QUOTE_IDENTIFIER is not set
                    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 "DG4ODBC"
                    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:DG4ODBC
                    Exiting hgogprd, rc=0
                    hostmstr: 0:      HOA After hoagprd
                    hostmstr: 0:      HOA Before hoainit
                    Entered hgoinit
                    HOCXU_COMP_CSET=1
                    HOCXU_DRV_CSET=560
                    HOCXU_DRV_NCHAR=873
                    HOCXU_DB_CSET=560
                    HOCXU_SEM_VER=110000
                    Entered hgolofn at 2012/12/07-16:36:01
                    HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so"
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLAllocHandle
                    symbol_peflctx=0xaaafa2f0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLBindCol
                    symbol_peflctx=0xaaafa430
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLBindParameter
                    symbol_peflctx=0xaaafac10
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLCancel
                    symbol_peflctx=0xaaafbe40
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLDescribeParam
                    symbol_peflctx=0xaab03c30
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLDisconnect
                    symbol_peflctx=0xaab04070
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLEndTran
                    symbol_peflctx=0xaab06870
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLExecute
                    symbol_peflctx=0xaab07ee0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLFetch
                    symbol_peflctx=0xaab08650
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLFreeHandle
                    symbol_peflctx=0xaab0a0e0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLFreeStmt
                    symbol_peflctx=0xaab0a100
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetData
                    symbol_peflctx=0xaab0b6e0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetEnvAttr
                    symbol_peflctx=0xaab0e810
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetFunctions
                    symbol_peflctx=0xaab0eb80
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLMoreResults
                    symbol_peflctx=0xaab105b0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLNumResultCols
                    symbol_peflctx=0xaab11110
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLParamData
                    symbol_peflctx=0xaab11410
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLPutData
                    symbol_peflctx=0xaab131b0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLRowCount
                    symbol_peflctx=0xaab135d0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLSetEnvAttr
                    symbol_peflctx=0xaab154e0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLSetDescRec
                    symbol_peflctx=0xaab152c0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLColAttribute
                    symbol_peflctx=0xaaafc6d0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLColumns
                    symbol_peflctx=0xaaafdf80
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLConnect
                    symbol_peflctx=0xaab017b0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLDescribeCol
                    symbol_peflctx=0xaab03500
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLDriverConnect
                    symbol_peflctx=0xaab04b40
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLExecDirect
                    symbol_peflctx=0xaab07990
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLForeignKeys
                    symbol_peflctx=0xaab08f20
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetConnectAttr
                    symbol_peflctx=0xaab0a430
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagField
                    symbol_peflctx=0xaab0d490
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagRec
                    symbol_peflctx=0xaab0e090
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetInfo
                    symbol_peflctx=0xaab0f570
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetStmtAttr
                    symbol_peflctx=0xaab0f810
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLGetTypeInfo
                    symbol_peflctx=0xaab10210
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLPrepare
                    symbol_peflctx=0xaab11b60
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLPrimaryKeys
                    symbol_peflctx=0xaab12040
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLProcedureColumns
                    symbol_peflctx=0xaab125f0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLProcedures
                    symbol_peflctx=0xaab12c40
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLSetConnectAttr
                    symbol_peflctx=0xaab13870
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLSetStmtAttr
                    symbol_peflctx=0xaab16830
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLSetDescField
                    symbol_peflctx=0xaab14f40
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLStatistics
                    symbol_peflctx=0xaab180d0
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Entered hgolofns at 2012/12/07-16:36:01
                    libname=/usr/lib64/libodbc.so, funcname=SQLTables
                    symbol_peflctx=0xaab18d40
                    hoaerr:0
                    Exiting hgolofns at 2012/12/07-16:36:01
                    Exiting hgolofn, rc=0 at 2012/12/07-16:36:01
                    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 ".,"
                    Exiting hgoinit, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoainit
                    hostmstr: 0:      HOA Before hoalgon
                    Entered hgolgon at 2012/12/07-16:36:01
                    reco:0, name:OracleUser, tflag:0
                    Entered hgosuec at 2012/12/07-16:36:01
                    Exiting hgosuec, rc=0 at 2012/12/07-16:36:01
                    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 OracleUser as default value for "HS_FDS_DEFAULT_OWNER"
                    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
                    Entered hgocont at 2012/12/07-16:36:01
                    HS_FDS_CONNECT_INFO = "mssql"
                    RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
                    Entered hgogenconstr at 2012/12/07-16:36:01
                    dsn:mssql, name:OracleUser
                    optn:
                    ##>Connect Parameters (len=38)<##
                    ## DSN=mssql;
                    #! UID=OracleUser;
                    #! PWD=*
                    Exiting hgogenconstr, rc=0 at 2012/12/07-16:36:01
                    DriverName:libsqlncli-11.0.so.1790.0, DriverVer:11.00.1790
                    DBMS Name:Microsoft SQL Server, DBMS Version:10.50.1617
                    Exiting hgocont, rc=0 at 2012/12/07-16:36:01
                    SQLGetInfo returns Y for SQL_CATALOG_NAME
                    SQLGetInfo returns 128 for SQL_MAX_CATALOG_NAME_LEN
                    Exiting hgolgon, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoalgon
                    hostmstr: 0: RPC Before Upload Caps
                    hostmstr: 0:      HOA Before hoaulcp
                    Entered hgoulcp at 2012/12/07-16:36:01
                    Entered hgowlst at 2012/12/07-16:36:01
                    Exiting hgowlst, rc=0 at 2012/12/07-16:36:01
                    SQLGetInfo returns " for SQL_IDENTIFIER_QUOTE_CHAR
                    SQLGetInfo returns Y for SQL_COLUMN_ALIAS
                    3 instance capabilities will be uploaded
                    capno:1989, context:0x00000000, add-info: 0
                    capno:1991, context:0x0001ffff, add-info: 0
                    capno:1992, context:0x0001ffff, add-info: 0
                    Exiting hgoulcp, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoaulcp
                    hostmstr: 0: RPC After Upload Caps
                    hostmstr: 0: RPC Before Upload DDTR
                    hostmstr: 0:      HOA Before hoauldt
                    Entered hgouldt at 2012/12/07-16:36:01
                    0 instance DD translations were uploaded
                    Exiting hgouldt, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoauldt
                    hostmstr: 0: RPC After Upload DDTR
                    hostmstr: 0: RPC Before Begin Trans
                    hostmstr: 0:      HOA Before hoabegn
                    Entered hgobegn at 2012/12/07-16:36:01
                    tflag:0 , initial:1
                    hoi:0xc8b24548, ttid (len 42) is ...
                    00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                    10: 502E434F 4D2E6365 63356661 38322E38 [P.COM.cec5fa82.8]
                    20: 2E32342E 32343030 3532 [.24.240052]
                    tbid (len 39) is ...
                    00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                    10: 502E434F 4D5B382E 32342E32 34303035 [P.COM[8.24.24005]
                    20: 325D5B31 2E345D [2][1.4]]
                    TXN Capable:2, Isolation Option:0x2f
                    Exiting hgobegn, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoabegn
                    hostmstr: 0: RPC After Begin Trans
                    hostmstr: 0: RPC Before Describe Table
                    hostmstr: 0:      HOA Before hoadtab
                    Entered hgodtab at 2012/12/07-16:36:01
                    count:1
                    table: emptest
                    Entered hgopdsc at 2012/12/07-16:36:01
                    Describing procedure OracleUser.emptest
                    Output hoada
                    hgopdsc, line 1298: NO hoada to print
                    Exiting hgopdsc, rc=942 at 2012/12/07-16:36:01
                    The hoada for table emptest follows...
                    hgodtab, line 651: NO hoada to print
                    Exiting hgodtab, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoadtab
                    hostmstr: 0: RPC After Describe Table
                    hostmstr: 0: RPC Before SQL Bundling
                    hostmstr: 0:      HOA Before hoxpars
                    Entered hgopars, cursor id 1 at 2012/12/07-16:36:01
                    type:0
                    SQL text from hgopars, id=1, len=23 ...
                    00: 53454C45 4354202A 2046524F 4D202265 [SELECT * FROM "e]
                    10: 6D707465 737422 [mptest"]
                    Exiting hgopars, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxpars
                    hostmstr: 0: RPC After SQL Bundling
                    hostmstr: 0: RPC Before SQL Bundling
                    hostmstr: 0:      HOA Before hoxopen
                    Entered hgoopen, cursor id 1 at 2012/12/07-16:36:01
                    hgoopen, line 83: NO hoada to print
                    Exiting hgoopen, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxopen
                    hostmstr: 0:      HOA Before hoxdscr
                    Entered hgodscr, cursor id 1 at 2012/12/07-16:36:01
                    Entered hgopcda at 2012/12/07-16:36:01
                    Column:1(empnumber): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                    Exiting hgopcda, rc=0 at 2012/12/07-16:36:01
                    Entered hgopcda at 2012/12/07-16:36:01
                    Column:2(empname): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                    Exiting hgopcda, rc=0 at 2012/12/07-16:36:01
                    Entered hgopcda at 2012/12/07-16:36:01
                    Column:3(telephone): dtype:2 (NUMERIC), prc/scl:18/0, nullbl:1, octet:20, sign:1, radix:0
                    Exiting hgopcda, rc=0 at 2012/12/07-16:36:01
                    hgodscr, line 506: Printing hoada @ 0x9c29d38
                    MAX:3, ACTUAL:3, 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
                    1 CHAR Y 20 20 128/ 10 873 0 40 empnumber
                    1 CHAR Y 20 20 128/ 10 873 0 40 empname
                    3 DECIMAL Y 20 20 18/ 0 0 0 0 telephone
                    Exiting hgodscr, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxdscr
                    hostmstr: 0: RPC After SQL Bundling
                    hostmstr: 0: RPC Before SQL Bundling
                    hostmstr: 0:      HOA Before hoxclse
                    Entered hgoclse, cursor id 1 at 2012/12/07-16:36:01
                    Exiting hgoclse, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxclse
                    hostmstr: 0:      HOA Before hoadafr
                    Entered hgodafr, cursor id 1 at 2012/12/07-16:36:01
                    Exiting hgodafr, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoadafr
                    hostmstr: 0:      HOA Before hoxpars
                    Entered hgopars, cursor id 1 at 2012/12/07-16:36:01
                    type:0
                    SQL text from hgopars, id=1, len=67 ...
                    00: 53454C45 43542041 312E2265 6D706E75 [SELECT A1."empnu]
                    10: 6D626572 222C4131 2E22656D 706E616D [mber",A1."empnam]
                    20: 65222C41 312E2274 656C6570 686F6E65 [e",A1."telephone]
                    30: 22204652 4F4D2022 656D7074 65737422 [" FROM "emptest"]
                    40: 204131 [ A1]
                    Exiting hgopars, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxpars
                    hostmstr: 0:      HOA Before hoxopen
                    Entered hgoopen, cursor id 1 at 2012/12/07-16:36:01
                    hgoopen, line 83: NO hoada to print
                    Exiting hgoopen, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxopen
                    hostmstr: 0:      HOA Before hoxdscr
                    Entered hgodscr, cursor id 1 at 2012/12/07-16:36:01
                    Entered hgopcda at 2012/12/07-16:36:01
                    Column:1(empnumber): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                    Exiting hgopcda, rc=0 at 2012/12/07-16:36:01
                    Entered hgopcda at 2012/12/07-16:36:01
                    Column:2(empname): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                    Exiting hgopcda, rc=0 at 2012/12/07-16:36:01
                    Entered hgopcda at 2012/12/07-16:36:01
                    Column:3(telephone): dtype:2 (NUMERIC), prc/scl:18/0, nullbl:1, octet:20, sign:1, radix:0
                    Exiting hgopcda, rc=0 at 2012/12/07-16:36:01
                    hgodscr, line 506: Printing hoada @ 0x9c29d38
                    MAX:3, ACTUAL:3, 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
                    1 CHAR Y 20 20 128/ 10 873 0 40 empnumber
                    1 CHAR Y 20 20 128/ 10 873 0 40 empname
                    3 DECIMAL Y 20 20 18/ 0 0 0 0 telephone
                    Exiting hgodscr, rc=0 at 2012/12/07-16:36:01
                    hostmstr: 0:      HOA After hoxdscr
                    hostmstr: 0: RPC After SQL Bundling
                    hostmstr: 0: RPC Before Fetch Row
                    hostmstr: 0:      HOA Before hoaftch
                    Entered hgoftch, cursor id 1 at 2012/12/07-16:36:01
                    hgoftch, line 117: Printing hoada @ 0x9c29d38
                    MAX:3, ACTUAL:3, 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
                    1 CHAR Y 20 20 128/ 10 873 0 40 empnumber
                    1 CHAR Y 20 20 128/ 10 873 0 40 empname
                    3 DECIMAL Y 20 20 18/ 0 0 0 0 telephone
                    SQLBindCol: column 1, cdatatype: -8, bflsz: 21
                    SQLBindCol: column 2, cdatatype: -8, bflsz: 21
                    SQLBindCol: column 3, cdatatype: 1, bflsz: 20
                    Entered hgopoer at 2012/12/07-16:36:01
                    hgopoer, line 159: got native error 0 and sqlstate 01004; message follows...
                    [Microsoft][SQL Server Native Client 11.0]String data, right truncation[Microsoft][SQL Server Native Client 11.0]String data, right truncation
                    Exiting hgopoer, rc=0 at 2012/12/07-16:36:01
                    hgoftch, line 699: calling SQLGetData got sqlstate 01004
                    1 rows fetched
                    Exiting hgoftch, rc=28500 at 2012/12/07-16:36:01 with error ptr FILE:hgoftch.c LINE:699 FUNCTION:hgoftch() ID:Row error while doing array fetch
                    hostmstr: 0:      HOA After hoaftch
                    hostmstr: 0: RPC After Fetch Row
                    hostmstr: 0: RPC Before Commit Trans
                    hostmstr: 0:      HOA Before hoxclse
                    Entered hgoclse, cursor id 1 at 2012/12/07-16:36:06
                    Exiting hgoclse, rc=0 at 2012/12/07-16:36:06
                    hostmstr: 0:      HOA After hoxclse
                    hostmstr: 0:      HOA Before hoadafr
                    Entered hgodafr, cursor id 1 at 2012/12/07-16:36:06
                    Exiting hgodafr, rc=0 at 2012/12/07-16:36:06
                    hostmstr: 0:      HOA After hoadafr
                    hostmstr: 0:      HOA Before hoacomm
                    Entered hgocomm at 2012/12/07-16:36:06
                    keepinfo:0, tflag:1
                    00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                    10: 502E434F 4D2E6365 63356661 38322E38 [P.COM.cec5fa82.8]
                    20: 2E32342E 32343030 3532 [.24.240052]
                    tbid (len 39) is ...
                    00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                    10: 502E434F 4D5B382E 32342E32 34303035 [P.COM[8.24.24005]
                    20: 325D5B31 2E345D [2][1.4]]
                    cmt(0):
                    Entered hgocpctx at 2012/12/07-16:36:06
                    Exiting hgocpctx, rc=0 at 2012/12/07-16:36:06
                    Exiting hgocomm, rc=0 at 2012/12/07-16:36:06
                    hostmstr: 0:      HOA After hoacomm
                    hostmstr: 0: RPC After Commit Trans
                    hostmstr: 0: RPC Before Logoff
                    hostmstr: 0:      HOA Before hoalgof
                    Entered hgolgof at 2012/12/07-16:36:06
                    tflag:1
                    Exiting hgolgof, rc=0 at 2012/12/07-16:36:06
                    hostmstr: 0:      HOA After hoalgof
                    hostmstr: 0: RPC After Logoff
                    hostmstr: 0: RPC Before Exit Agent
                    hostmstr: 0:      HOA Before hoaexit
                    Entered hgoexit at 2012/12/07-16:36:06
                    Exiting hgoexit, rc=0 at 2012/12/07-16:36:06
                    hostmstr: 0:      HOA After hoaexit
                    hostmstr: 0: RPC After Exit Agent
                    ---------------------------------------------------------

                    This is just an additional information that this oracle database is E-business database and "FTEST" is the SID.

                    Thank You.
                    • 7. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                      Kgronau-Oracle
                      Could you please provide the source of the table description (the way your table is defined at the SQl Server side)?

                      The table you try to select from contains character and numeric columns - when you select from each column separately, which one is causing the error?
                      select "empnumber" from "emptest"@dblink>;
                      select "empname" from "emptest"@dblink>;
                      select "telephone" from "emptest"@dblink>;

                      - Klaus
                      • 8. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                        User353235
                        Hi kgronau,
                        Thanks for your update.

                        SQL> select "empnumber" from "emptest"@mssqltest;
                        ERROR:
                        ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
                        [Microsoft][SQL Server Native Client 11.0]String data, right truncation
                        ORA-02063: preceding 2 lines from MSSQLTEST



                        no rows selected

                        SQL> select "empname" from "emptest"@mssqltest;
                        ERROR:
                        ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
                        [Microsoft][SQL Server Native Client 11.0]String data, right truncation
                        ORA-02063: preceding 2 lines from MSSQLTEST



                        no rows selected

                        SQL> select "telephone" from "emptest"@mssqltest;

                        telephone
                        ----------
                        123
                        • 9. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                          User353235
                          Hi Kgronau,

                          I could now able to select from all other tables (system related). I think the issue is with column char types.

                          Many Thanks for your support.

                          Thank you,
                          Mohammed.
                          • 10. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                            Kgronau-Oracle
                            Mohammed,
                            Is the column defined at the SQl Server side as char or nchar and what's its precision?

                            Could you please add to the gateway config file HS_NLS_NCHAR=UCS2 and then test again?
                            • 11. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                              User353235
                              Columns details:
                              empnumber (nchar(10), null)
                              empname (nchar(10), null)
                              telephone (numeric(18,0) null)

                              The same error persists after adding HS_NLS_NCHAR=UCS2

                              SQL> select "empname" from "emptest"@mssqltest;
                              ERROR:
                              ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
                              [Microsoft][SQL Server Native Client 11.0]String data, right truncation
                              ORA-02063: preceding 2 lines from MSSQLTEST
                              • 12. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                                Kgronau-Oracle
                                Could you please post a gateway trace level 255 after you have set HS_NLS_NCHAR=UCS2 and when selecting from your table?
                                • 13. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                                  User353235
                                  Oracle Corporation --- MONDAY DEC 10 2012 12:02:15.149


                                  Heterogeneous Agent Release
                                  11.1.0.7.0




                                  Oracle Corporation --- MONDAY DEC 10 2012 12:02:15.149

                                  Version 11.1.0.7.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_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"
                                  setting HS_FDS_FETCH_ROWS to default of "100"
                                  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
                                  Parameter HS_FDS_QUOTE_IDENTIFIER is not set
                                  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 "DG4ODBC"
                                  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:DG4ODBC
                                  Exiting hgogprd, rc=0
                                  hostmstr: 0: HOA After hoagprd
                                  hostmstr: 0: HOA Before hoainit
                                  Entered hgoinit
                                  HOCXU_COMP_CSET=1
                                  HOCXU_DRV_CSET=560
                                  HOCXU_DRV_NCHAR=873
                                  HOCXU_DB_CSET=560
                                  HOCXU_SEM_VER=110000
                                  Entered hgolofn at 2012/12/10-12:02:15
                                  HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so"
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLAllocHandle
                                  symbol_peflctx=0xa60082f0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLBindCol
                                  symbol_peflctx=0xa6008430
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLBindParameter
                                  symbol_peflctx=0xa6008c10
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLCancel
                                  symbol_peflctx=0xa6009e40
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLDescribeParam
                                  symbol_peflctx=0xa6011c30
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLDisconnect
                                  symbol_peflctx=0xa6012070
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLEndTran
                                  symbol_peflctx=0xa6014870
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLExecute
                                  symbol_peflctx=0xa6015ee0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLFetch
                                  symbol_peflctx=0xa6016650
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLFreeHandle
                                  symbol_peflctx=0xa60180e0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLFreeStmt
                                  symbol_peflctx=0xa6018100
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetData
                                  symbol_peflctx=0xa60196e0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetEnvAttr
                                  symbol_peflctx=0xa601c810
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetFunctions
                                  symbol_peflctx=0xa601cb80
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLMoreResults
                                  symbol_peflctx=0xa601e5b0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLNumResultCols
                                  symbol_peflctx=0xa601f110
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLParamData
                                  symbol_peflctx=0xa601f410
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLPutData
                                  symbol_peflctx=0xa60211b0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLRowCount
                                  symbol_peflctx=0xa60215d0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLSetEnvAttr
                                  symbol_peflctx=0xa60234e0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLSetDescRec
                                  symbol_peflctx=0xa60232c0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLColAttribute
                                  symbol_peflctx=0xa600a6d0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLColumns
                                  symbol_peflctx=0xa600bf80
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLConnect
                                  symbol_peflctx=0xa600f7b0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLDescribeCol
                                  symbol_peflctx=0xa6011500
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLDriverConnect
                                  symbol_peflctx=0xa6012b40
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLExecDirect
                                  symbol_peflctx=0xa6015990
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLForeignKeys
                                  symbol_peflctx=0xa6016f20
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetConnectAttr
                                  symbol_peflctx=0xa6018430
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagField
                                  symbol_peflctx=0xa601b490
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagRec
                                  symbol_peflctx=0xa601c090
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetInfo
                                  symbol_peflctx=0xa601d570
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetStmtAttr
                                  symbol_peflctx=0xa601d810
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLGetTypeInfo
                                  symbol_peflctx=0xa601e210
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLPrepare
                                  symbol_peflctx=0xa601fb60
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLPrimaryKeys
                                  symbol_peflctx=0xa6020040
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLProcedureColumns
                                  symbol_peflctx=0xa60205f0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLProcedures
                                  symbol_peflctx=0xa6020c40
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLSetConnectAttr
                                  symbol_peflctx=0xa6021870
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLSetStmtAttr
                                  symbol_peflctx=0xa6024830
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLSetDescField
                                  symbol_peflctx=0xa6022f40
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLStatistics
                                  symbol_peflctx=0xa60260d0
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Entered hgolofns at 2012/12/10-12:02:15
                                  libname=/usr/lib64/libodbc.so, funcname=SQLTables
                                  symbol_peflctx=0xa6026d40
                                  hoaerr:0
                                  Exiting hgolofns at 2012/12/10-12:02:15
                                  Exiting hgolofn, rc=0 at 2012/12/10-12:02:15
                                  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 ".,"
                                  Exiting hgoinit, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoainit
                                  hostmstr: 0: HOA Before hoalgon
                                  Entered hgolgon at 2012/12/10-12:02:15
                                  reco:0, name:OracleUser, tflag:0
                                  Entered hgosuec at 2012/12/10-12:02:15
                                  Exiting hgosuec, rc=0 at 2012/12/10-12:02:15
                                  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 OracleUser as default value for "HS_FDS_DEFAULT_OWNER"
                                  HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
                                  Entered hgocont at 2012/12/10-12:02:15
                                  HS_FDS_CONNECT_INFO = "mssql"
                                  RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
                                  Entered hgogenconstr at 2012/12/10-12:02:15
                                  dsn:mssql, name:OracleUser
                                  optn:
                                  ##>Connect Parameters (len=38)<##
                                  ## DSN=mssql;
                                  #! UID=OracleUser;
                                  #! PWD=*
                                  Exiting hgogenconstr, rc=0 at 2012/12/10-12:02:15
                                  DriverName:libsqlncli-11.0.so.1790.0, DriverVer:11.00.1790
                                  DBMS Name:Microsoft SQL Server, DBMS Version:10.50.1617
                                  Exiting hgocont, rc=0 at 2012/12/10-12:02:15
                                  SQLGetInfo returns Y for SQL_CATALOG_NAME
                                  SQLGetInfo returns 128 for SQL_MAX_CATALOG_NAME_LEN
                                  Exiting hgolgon, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoalgon
                                  hostmstr: 0: RPC Before Upload Caps
                                  hostmstr: 0: HOA Before hoaulcp
                                  Entered hgoulcp at 2012/12/10-12:02:15
                                  Entered hgowlst at 2012/12/10-12:02:15
                                  Exiting hgowlst, rc=0 at 2012/12/10-12:02:15
                                  SQLGetInfo returns " for SQL_IDENTIFIER_QUOTE_CHAR
                                  SQLGetInfo returns Y for SQL_COLUMN_ALIAS
                                  3 instance capabilities will be uploaded
                                  capno:1989, context:0x00000000, add-info: 0
                                  capno:1991, context:0x0001ffff, add-info: 0
                                  capno:1992, context:0x0001ffff, add-info: 0
                                  Exiting hgoulcp, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoaulcp
                                  hostmstr: 0: RPC After Upload Caps
                                  hostmstr: 0: RPC Before Upload DDTR
                                  hostmstr: 0: HOA Before hoauldt
                                  Entered hgouldt at 2012/12/10-12:02:15
                                  0 instance DD translations were uploaded
                                  Exiting hgouldt, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoauldt
                                  hostmstr: 0: RPC After Upload DDTR
                                  hostmstr: 0: RPC Before Begin Trans
                                  hostmstr: 0: HOA Before hoabegn
                                  Entered hgobegn at 2012/12/10-12:02:15
                                  tflag:0 , initial:1
                                  hoi:0x9a060b68, ttid (len 42) is ...
                                  00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                                  10: 502E434F 4D2E6365 63356661 38322E31 [P.COM.cec5fa82.1]
                                  20: 302E322E 34343330 3232 [0.2.443022]
                                  tbid (len 39) is ...
                                  00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                                  10: 502E434F 4D5B3130 2E322E34 34333032 [P.COM[10.2.44302]
                                  20: 325D5B31 2E345D [2][1.4]]
                                  TXN Capable:2, Isolation Option:0x2f
                                  Exiting hgobegn, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoabegn
                                  hostmstr: 0: RPC After Begin Trans
                                  hostmstr: 0: RPC Before Describe Table
                                  hostmstr: 0: HOA Before hoadtab
                                  Entered hgodtab at 2012/12/10-12:02:15
                                  count:1
                                  table: emptest
                                  Entered hgopdsc at 2012/12/10-12:02:15
                                  Describing procedure OracleUser.emptest
                                  Output hoada
                                  hgopdsc, line 1298: NO hoada to print
                                  Exiting hgopdsc, rc=942 at 2012/12/10-12:02:15
                                  The hoada for table emptest follows...
                                  hgodtab, line 651: NO hoada to print
                                  Exiting hgodtab, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoadtab
                                  hostmstr: 0: RPC After Describe Table
                                  hostmstr: 0: RPC Before SQL Bundling
                                  hostmstr: 0: HOA Before hoxpars
                                  Entered hgopars, cursor id 1 at 2012/12/10-12:02:15
                                  type:0
                                  SQL text from hgopars, id=1, len=23 ...
                                  00: 53454C45 4354202A 2046524F 4D202265 [SELECT * FROM "e]
                                  10: 6D707465 737422 [mptest"]
                                  Exiting hgopars, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxpars
                                  hostmstr: 0: RPC After SQL Bundling
                                  hostmstr: 0: RPC Before SQL Bundling
                                  hostmstr: 0: HOA Before hoxopen
                                  Entered hgoopen, cursor id 1 at 2012/12/10-12:02:15
                                  hgoopen, line 83: NO hoada to print
                                  Exiting hgoopen, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxopen
                                  hostmstr: 0: HOA Before hoxdscr
                                  Entered hgodscr, cursor id 1 at 2012/12/10-12:02:15
                                  Entered hgopcda at 2012/12/10-12:02:15
                                  Column:1(empnumber): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                                  Exiting hgopcda, rc=0 at 2012/12/10-12:02:15
                                  Entered hgopcda at 2012/12/10-12:02:15
                                  Column:2(empname): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                                  Exiting hgopcda, rc=0 at 2012/12/10-12:02:15
                                  Entered hgopcda at 2012/12/10-12:02:15
                                  Column:3(telephone): dtype:2 (NUMERIC), prc/scl:18/0, nullbl:1, octet:20, sign:1, radix:0
                                  Exiting hgopcda, rc=0 at 2012/12/10-12:02:15
                                  hgodscr, line 506: Printing hoada @ 0x193f5b08
                                  MAX:3, ACTUAL:3, 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
                                  1 CHAR Y 20 20 128/ 10 873 0 40 empnumber
                                  1 CHAR Y 20 20 128/ 10 873 0 40 empname
                                  3 DECIMAL Y 20 20 18/ 0 0 0 0 telephone
                                  Exiting hgodscr, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxdscr
                                  hostmstr: 0: RPC After SQL Bundling
                                  hostmstr: 0: RPC Before SQL Bundling
                                  hostmstr: 0: HOA Before hoxclse
                                  Entered hgoclse, cursor id 1 at 2012/12/10-12:02:15
                                  Exiting hgoclse, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxclse
                                  hostmstr: 0: HOA Before hoadafr
                                  Entered hgodafr, cursor id 1 at 2012/12/10-12:02:15
                                  Exiting hgodafr, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoadafr
                                  hostmstr: 0: HOA Before hoxpars
                                  Entered hgopars, cursor id 1 at 2012/12/10-12:02:15
                                  type:0
                                  SQL text from hgopars, id=1, len=67 ...
                                  00: 53454C45 43542041 312E2265 6D706E75 [SELECT A1."empnu]
                                  10: 6D626572 222C4131 2E22656D 706E616D [mber",A1."empnam]
                                  20: 65222C41 312E2274 656C6570 686F6E65 [e",A1."telephone]
                                  30: 22204652 4F4D2022 656D7074 65737422 [" FROM "emptest"]
                                  40: 204131 [ A1]
                                  Exiting hgopars, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxpars
                                  hostmstr: 0: HOA Before hoxopen
                                  Entered hgoopen, cursor id 1 at 2012/12/10-12:02:15
                                  hgoopen, line 83: NO hoada to print
                                  Exiting hgoopen, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxopen
                                  hostmstr: 0: HOA Before hoxdscr
                                  Entered hgodscr, cursor id 1 at 2012/12/10-12:02:15
                                  Entered hgopcda at 2012/12/10-12:02:15
                                  Column:1(empnumber): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                                  Exiting hgopcda, rc=0 at 2012/12/10-12:02:15
                                  Entered hgopcda at 2012/12/10-12:02:15
                                  Column:2(empname): dtype:-8 (WCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
                                  Exiting hgopcda, rc=0 at 2012/12/10-12:02:15
                                  Entered hgopcda at 2012/12/10-12:02:15
                                  Column:3(telephone): dtype:2 (NUMERIC), prc/scl:18/0, nullbl:1, octet:20, sign:1, radix:0
                                  Exiting hgopcda, rc=0 at 2012/12/10-12:02:15
                                  hgodscr, line 506: Printing hoada @ 0x193f5b08
                                  MAX:3, ACTUAL:3, 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
                                  1 CHAR Y 20 20 128/ 10 873 0 40 empnumber
                                  1 CHAR Y 20 20 128/ 10 873 0 40 empname
                                  3 DECIMAL Y 20 20 18/ 0 0 0 0 telephone
                                  Exiting hgodscr, rc=0 at 2012/12/10-12:02:15
                                  hostmstr: 0: HOA After hoxdscr
                                  hostmstr: 0: RPC After SQL Bundling
                                  hostmstr: 0: RPC Before Fetch Row
                                  hostmstr: 0: HOA Before hoaftch
                                  Entered hgoftch, cursor id 1 at 2012/12/10-12:02:15
                                  hgoftch, line 117: Printing hoada @ 0x193f5b08
                                  MAX:3, ACTUAL:3, 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
                                  1 CHAR Y 20 20 128/ 10 873 0 40 empnumber
                                  1 CHAR Y 20 20 128/ 10 873 0 40 empname
                                  3 DECIMAL Y 20 20 18/ 0 0 0 0 telephone
                                  SQLBindCol: column 1, cdatatype: -8, bflsz: 21
                                  SQLBindCol: column 2, cdatatype: -8, bflsz: 21
                                  SQLBindCol: column 3, cdatatype: 1, bflsz: 20
                                  Entered hgopoer at 2012/12/10-12:02:15
                                  hgopoer, line 159: got native error 0 and sqlstate 01004; message follows...
                                  [Microsoft][SQL Server Native Client 11.0]String data, right truncation[Microsoft][SQL Server Native Client 11.0]String data, right truncation
                                  Exiting hgopoer, rc=0 at 2012/12/10-12:02:15
                                  hgoftch, line 699: calling SQLGetData got sqlstate 01004
                                  1 rows fetched
                                  Exiting hgoftch, rc=28500 at 2012/12/10-12:02:15 with error ptr FILE:hgoftch.c LINE:699 FUNCTION:hgoftch() ID:Row error while doing array fetch
                                  hostmstr: 0: HOA After hoaftch
                                  hostmstr: 0: RPC After Fetch Row
                                  hostmstr: 0: RPC Before Commit Trans
                                  hostmstr: 0: HOA Before hoxclse
                                  Entered hgoclse, cursor id 1 at 2012/12/10-12:02:17
                                  Exiting hgoclse, rc=0 at 2012/12/10-12:02:17
                                  hostmstr: 0: HOA After hoxclse
                                  hostmstr: 0: HOA Before hoadafr
                                  Entered hgodafr, cursor id 1 at 2012/12/10-12:02:17
                                  Exiting hgodafr, rc=0 at 2012/12/10-12:02:17
                                  hostmstr: 0: HOA After hoadafr
                                  hostmstr: 0: HOA Before hoacomm
                                  Entered hgocomm at 2012/12/10-12:02:17
                                  keepinfo:0, tflag:1
                                  00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                                  10: 502E434F 4D2E6365 63356661 38322E31 [P.COM.cec5fa82.1]
                                  20: 302E322E 34343330 3232 [0.2.443022]
                                  tbid (len 39) is ...
                                  00: 46544553 542E4641 4B494548 47524F55 [FTEST.FAKIEHGROU]
                                  10: 502E434F 4D5B3130 2E322E34 34333032 [P.COM[10.2.44302]
                                  20: 325D5B31 2E345D [2][1.4]]
                                  cmt(0):
                                  Entered hgocpctx at 2012/12/10-12:02:17
                                  Exiting hgocpctx, rc=0 at 2012/12/10-12:02:17
                                  Exiting hgocomm, rc=0 at 2012/12/10-12:02:17
                                  hostmstr: 0: HOA After hoacomm
                                  hostmstr: 0: RPC After Commit Trans
                                  hostmstr: 0: RPC Before Logoff
                                  hostmstr: 0: HOA Before hoalgof
                                  Entered hgolgof at 2012/12/10-12:02:17
                                  tflag:1
                                  Exiting hgolgof, rc=0 at 2012/12/10-12:02:17
                                  hostmstr: 0: HOA After hoalgof
                                  hostmstr: 0: RPC After Logoff
                                  hostmstr: 0: RPC Before Exit Agent
                                  hostmstr: 0: HOA Before hoaexit
                                  Entered hgoexit at 2012/12/10-12:02:17
                                  Exiting hgoexit, rc=0 at 2012/12/10-12:02:17
                                  hostmstr: 0: HOA After hoaexit
                                  hostmstr: 0: RPC After Exit Agent
                                  • 14. Re: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
                                    Kgronau-Oracle
                                    Hm - the trace shows:
                                    HS_NLS_NCHAR to default of "AL32UTF8

                                    So it looks like HS_NLS_NCHAR=UCS2 isn't set or used. When you change a gateway init parameter, then you have to make sure that you start a new gateway session as the gateway is only reading its init file when starting a new session.

                                    So please make sure that you close the database link or even better just start a new SQL*Plus session after setting HS_NLS_NCHAR=UCS2 in the gateway init file.
                                    1 2 Previous Next