1 2 Previous Next 23 Replies Latest reply: Nov 15, 2012 6:22 PM by 974537 Go to original post RSS
      • 15. Re: ORA-02063: preceding line from HSLINK
        880492
        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-Oracle
          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
            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
              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-Oracle
                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
                  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-Oracle
                    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
                      Thanks kgronau!!!
                      It worked!!!
                      • 23. Re: ORA-02063: preceding line from HSLINK
                        974537
                        it worked for me too
                        thanks
                        1 2 Previous Next