This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Feb 19, 2013 12:22 AM by User353235 RSS

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

User353235 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

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