This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Nov 15, 2012 4:22 PM by 974537 Go to original post RSS
  • 15. Re: ORA-02063: preceding line from HSLINK
    880492 Newbie
    Currently Being Moderated
    Thanks kgronau ,

    managed to compile as 64bit both the driver and manager. i can connect through isql but cannot through oracle sqlplus. getting below error


    [unixODBC][FreeTDS][SQL Server]Unable to connect to data
    source[unixODBC][FreeTDS][SQL Server]Adaptive Server connection
    failed[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
    ORA-02063: preceding 2 lines from
  • 16. Re: ORA-02063: preceding line from HSLINK
    kgronau Guru
    Currently Being Moderated
    These are the commands/settings I've used to compile FreeTDS on Solaris:
    CFLAGS="-m64 -DBUILD_REAL_64_BIT_MODE"
    export CFLAGS
    CXXFLAGS="-m64 -DBUILD_REAL_64_BIT_MODE"
    export CXXFLAGS
    CPPFLAGS="-DSIZEOF_LONG_INT=8"
    export CPPFLAGS
    ./configure prefix=/u01/odbc64/product/FreeTDS/0.91 with-unixodbc=/u01/odbc64/product/unixODBC enable-msdblib with-tdsver=8.0
    LD_LIBRARY_PATH=/u01/odbc64/product/unixODBC/lib:$LD_LIBRARY_PATH
    export LD_LIBRARY_PATH
    make
    sudo make install
  • 17. Re: ORA-02063: preceding line from HSLINK
    880492 Newbie
    Currently Being Moderated
    Thanks kgronau!!!

    Installed both the unixODBC 64bit and FreeTDS 64bit.

    I can connect in isql but cannot through oracle sqlplus:

    getting this error:

    SQL> SELECT * FROM Banks@EIMS;
    SELECT * FROM Banks@EIMS
    *
    ERROR at line 1:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    [unixODBC][FreeTDS][SQL Server]Unable to connect to data
    source[unixODBC][FreeTDS][SQL Server]Adaptive Server connection
    failed[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
    ORA-02063: preceding 2 lines from EIMS
  • 18. Re: ORA-02063: preceding line from HSLINK
    880492 Newbie
    Currently Being Moderated
    from trace logs:



    Oracle Corporation --- THURSDAY SEP 27 2012 13:28:02.131


    Heterogeneous Agent Release
    11.1.0.7.0




    Oracle Corporation --- THURSDAY SEP 27 2012 13:28:02.131

    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"
    setting HS_FDS_SUPPORT_STATISTICS to default of "TRUE"
    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 "EIMS"
    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:EIMS
    Exiting hgogprd, rc=0
    hostmstr: 50421760:      HOA After hoagprd
    hostmstr: 50429952:      HOA Before hoainit
    Entered hgoinit
    HOCXU_COMP_CSET=1
    HOCXU_DRV_CSET=178
    HOCXU_DRV_NCHAR=873
    HOCXU_DB_CSET=1
    HOCXU_SEM_VER=110000
    Entered hgolofn at 2012/09/27-13:28:02
    HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libodbc.so"
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLAllocHandle
    symbol_peflctx=0x7a51e860
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLBindCol
    symbol_peflctx=0x7a51ed38
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLBindParameter
    symbol_peflctx=0x7a51f780
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLCancel
    symbol_peflctx=0x7a521230
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeParam
    symbol_peflctx=0x7a52bbd0
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLDisconnect
    symbol_peflctx=0x7a52c250
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLEndTran
    symbol_peflctx=0x7a52f988
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLExecute
    symbol_peflctx=0x7a531558
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLFetch
    symbol_peflctx=0x7a532080
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLFreeHandle
    symbol_peflctx=0x7a5341f8
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLFreeStmt
    symbol_peflctx=0x7a534260
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetData
    symbol_peflctx=0x7a536740
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetEnvAttr
    symbol_peflctx=0x7a53ab70
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetFunctions
    symbol_peflctx=0x7a53b068
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLMoreResults
    symbol_peflctx=0x7a53da78
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLNumResultCols
    symbol_peflctx=0x7a53ea88
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLParamData
    symbol_peflctx=0x7a53ee88
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLPutData
    symbol_peflctx=0x7a5417b0
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLRowCount
    symbol_peflctx=0x7a541d10
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLSetEnvAttr
    symbol_peflctx=0x7a544360
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescRec
    symbol_peflctx=0x7a544138
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLColAttribute
    symbol_peflctx=0x7a521b80
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLColumns
    symbol_peflctx=0x7a524060
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLConnect
    symbol_peflctx=0x7a528e10
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeCol
    symbol_peflctx=0x7a52b240
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLDriverConnect
    symbol_peflctx=0x7a52d3c0
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLExecDirect
    symbol_peflctx=0x7a530e48
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLForeignKeys
    symbol_peflctx=0x7a532e38
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetConnectAttr
    symbol_peflctx=0x7a534770
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagField
    symbol_peflctx=0x7a5390c0
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagRec
    symbol_peflctx=0x7a53a298
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetInfo
    symbol_peflctx=0x7a53c148
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetStmtAttr
    symbol_peflctx=0x7a53c548
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLGetTypeInfo
    symbol_peflctx=0x7a53d528
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLPrepare
    symbol_peflctx=0x7a53f928
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLPrimaryKeys
    symbol_peflctx=0x7a540090
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLProcedureColumns
    symbol_peflctx=0x7a540868
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLProcedures
    symbol_peflctx=0x7a5410a8
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLSetConnectAttr
    symbol_peflctx=0x7a5420e8
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLSetStmtAttr
    symbol_peflctx=0x7a546260
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescField
    symbol_peflctx=0x7a543d98
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLStatistics
    symbol_peflctx=0x7a548958
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Entered hgolofns at 2012/09/27-13:28:02
    libname=/usr/local/lib/libodbc.so, funcname=SQLTables
    symbol_peflctx=0x7a549a98
    hoaerr:0
    Exiting hgolofns at 2012/09/27-13:28:02
    Exiting hgolofn, rc=0 at 2012/09/27-13:28:02
    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/09/27-13:28:02
    hostmstr: 51232768:      HOA After hoainit
    hostmstr: 51240960:      HOA Before hoalgon
    Entered hgolgon at 2012/09/27-13:28:02
    reco:0, name:DevelopersMCB, tflag:0
    Entered hgosuec at 2012/09/27-13:28:02
    Exiting hgosuec, rc=0 at 2012/09/27-13:28:02
    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 DevelopersMCB as default value for "HS_FDS_DEFAULT_OWNER"
    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
    Entered hgocont at 2012/09/27-13:28:02
    HS_FDS_CONNECT_INFO = "MSSQLTestServer"
    RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
    Entered hgogenconstr at 2012/09/27-13:28:02
    dsn:MSSQLTestServer, name:DevelopersMCB
    optn:
    ##>Connect Parameters (len=55)<##
    ## DSN=MSSQLTestServer;
    #! UID=DevelopersMCB;
    #! PWD=*
    Exiting hgogenconstr, rc=0 at 2012/09/27-13:28:02
    Entered hgopoer at 2012/09/27-13:28:02
    hgopoer, line 159: got native error 0 and sqlstate 08001; message follows...
    [unixODBC][FreeTDS][SQL Server]Unable to connect to data source[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
    Exiting hgopoer, rc=0 at 2012/09/27-13:28:02
    hgocont, line 1904: calling SqlDriverConnect got sqlstate 08001
    Exiting hgocont, rc=28500 at 2012/09/27-13:28:02 with error ptr FILE:hgocont.c LINE:1923 ID:Something other than invalid authorization
    Exiting hgolgon, rc=28500 at 2012/09/27-13:28:02 with error ptr FILE:hgolgon.c LINE:612 ID:Calling hgocont
    hostmstr: 52133888:      HOA After hoalgon
    hostmstr: 52142080: RPC Before Exit Agent
    hostmstr: 52150272:      HOA Before hoaexit
    Entered hgoexit at 2012/09/27-13:28:02
    Exiting hgoexit, rc=0 at 2012/09/27-13:28:02
    hostmstr: 52158464:      HOA After hoaexit
    hostmstr: 52166656: RPC After Exit Agent
  • 19. Re: ORA-02063: preceding line from HSLINK
    kgronau Guru
    Currently Being Moderated
    I commonly have these additional lines in the odbc.ini file:
    TDS_Version = 8.0
    QuotedId=YES
    for my FreeTDS related DSNs, just to make sure the correct TDS protocol version is used.

    Could you please add them and check again with dg4odbc? If it fails, please enable ODBC tracing for the ODBC Driver (for unixODBC commonly done in the odbcinst.ini file by adding a section called [ODBC] which then contains the TRACE=1 and TraceFile parameter including to a path where the DG4ODBC process is able to write to).
  • 20. Re: ORA-02063: preceding line from HSLINK
    880492 Newbie
    Currently Being Moderated
    Hi,

    I have added,

    TDS_Version = 8.0
    QuotedId=YES

    to /etc/odbc.ini

    root@adnerpapp # vi tds.datasource.template
    "tds.datasource.template" 9 lines, 202 characters
    [MSSQLTestServer]
    Driver = FreeTDS
    Description = EIMS TEST database
    Trace = No
    Server = 10.1.9.85
    Port = 1433
    Database = Elimisha_15th march'2012
    TDS_Version = 8.0
    QuotedId=YES

    root@adnerpapp # /usr/local/bin/odbcinst -i -s -f tds.datasource.template -l
    root@adnerpapp # cat /etc/odbc.ini
    [MSSQLTestServer]
    Driver = FreeTDS
    Description = EIMS TEST database
    Trace = No
    Server = 10.1.9.85
    Port = 1433
    Database = Elimisha_15th march'2012
    TDS_Version = 8.0
    QuotedId = YES

    root@adnerpapp #

    now getting new error: [FreeTDS][SQL Server]Invalid cursor state

    SQL> SELECT * FROM Banks@EIMS;
    SELECT * FROM Banks@EIMS
    *
    ERROR at line 1:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    [FreeTDS][SQL Server]Invalid cursor state
    ORA-02063: preceding 2 lines from EIMS


    ADDED to odbcinst.ini

    root@adnerpapp # cat /etc/odbcinst.ini
    [FreeTDS]
    Description = v0.91 with protocol v8.0
    Driver = /usr/local/freetds/lib/libtdsodbc.so
    UsageCount = 2

    [ODBC]
    TRACE = 1
    Trace File parameter = /u01db/oracle/EBLERP/db/tech_st/11.1.0/hs/log/
    UsageCount = 1

    Edited by: 877489 on Sep 27, 2012 3:49 AM
  • 21. Re: ORA-02063: preceding line from HSLINK
    kgronau Guru
    Currently Being Moderated
    commonly for this kind of error a trace would be very helpful. So I can just guess.
    Please add to your gateway init file:
    HS_FDS_SUPPORT_STATISTICS=FALSE
  • 22. Re: ORA-02063: preceding line from HSLINK
    880492 Newbie
    Currently Being Moderated
    Thanks kgronau!!!
    It worked!!!
  • 23. Re: ORA-02063: preceding line from HSLINK
    974537 Newbie
    Currently Being Moderated
    it worked for me too
    thanks
1 2 Previous Next

Legend

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