5 Replies Latest reply: Dec 3, 2012 1:12 AM by Kgronau-Oracle RSS

    Oracle 11R2 TO MSSQLServer via ODBC Hangs

    723623
      Hi everyone:

      I'm trying to connect from an Oracle 11.2.0.3 on Solaris 10 (64 bit SPARC) to a MS SQL server 2000 using openlink odbc drivers 6.1 for SQL Server.

      We can do a tnsping to the remore database and it works, but when we try to query any table from SQL Server connections hangs always in the same step.



      Oracle Corporation --- MONDAY NOV 26 2012 11:20:26.750


      Heterogeneous Agent Release
      11.2.0.2.0




      Oracle Corporation --- MONDAY NOV 26 2012 11:20:26.749

      Version 11.2.0.2.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
      Entered hgosdip
      setting HS_OPEN_CURSORS to default of 50
      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
      setting HS_FDS_RECOVERY_PWD to default value
      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
      setting HS_IDLE_TIMEOUT to default of 0
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "AL32UTF8"
      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
      setting HS_FDS_DATE_MAPPING to default of "DATE"
      setting HS_RPC_FETCH_REBLOCKING to default of "ON"
      HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
      setting HS_FDS_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_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
      Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
      setting HS_FDS_DELAYED_OPEN to default of "TRUE"
      setting HS_FDS_WORKAROUNDS to default of "0"
      Exiting hgosdip, rc=0
      ORACLE_SID is "CardHolders"
      Product-Info:
      Port Rls/Upd:2/0 PrdStat:0
      Agent:Oracle Database Gateway for ODBC
      Facility:hsa
      Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:CardHolders
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=31
      HOCXU_DRV_NCHAR=873
      HOCXU_DB_CSET=873
      HS_LANGUAGE is AMERICAN_AMERICA.WE8ISO8859P1
      rc=2147476520 attempting to get LANG environment variable.
      HOCXU_SEM_VER=112000
      Entered hgolofn at 2012/11/26-11:20:26
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/apex01/oraapex/ODBC_64/lib/sql_mt_lt.so"
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a170e68
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1724b0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a18db90
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a172520
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a18dce0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17dca0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a191240
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a182600
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a182cc0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a183270
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a183988
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a182d10
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17e190
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a184ec8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1876d8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a187928
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a18dc30
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a18dc88
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1887a0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17e130
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17dad8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a173ba0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a173ef0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a174560
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17dea0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a156d60
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17f070
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a183048
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1760a0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17c2f0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17db78
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a184390
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a184ac0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1873f8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1906d8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a191038
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a187dc8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a188048
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1886c8
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a1883a0
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a176040
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a190738
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a17c368
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a18e280
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Entered hgolofns at 2012/11/26-11:20:26
      symbol_peflctx=0x7a190b28
      hoaerr:0
      Exiting hgolofns at 2012/11/26-11:20:26
      Exiting hgolofn, rc=0 at 2012/11/26-11:20:26
      HOSGIP for "HS_OPEN_CURSORS" returned "50"
      HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
      Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
      treat_SQLLEN_as_compiled = 1
      Exiting hgoinit, rc=0 at 2012/11/26-11:20:26
      Entered hgolgon at 2012/11/26-11:20:26
      reco:0, name:SA, tflag:0
      Entered hgosuec at 2012/11/26-11:20:26
      Exiting hgosuec, rc=0 at 2012/11/26-11:20:26
      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
      using SA as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2012/11/26-11:20:26
      HS_FDS_CONNECT_INFO = "CardHolders"
      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
      Entered hgogenconstr at 2012/11/26-11:20:26
      dsn:CardHolders, name:SA
      optn:
      Entered hgocip at 2012/11/26-11:20:26
      dsn:CardHolders
      Exiting hgocip, rc=0 at 2012/11/26-11:20:26
      Exiting hgogenconstr, rc=0 at 2012/11/26-11:20:26


      We configured the odbc.ini, initDB.ora , listener.ora an tnsnmaes.ora as follows.

      [ODBC Data Sources]
      CardHolders = OpenLink SQL Server Lite Driver (multi threaded)

      *** odbc.ini
      [CardHolders]
      Driver = /apex01/oraapex/ODBC_64/lib/sql_mt_lt.so
      ServerType = SQLServer 2000
      Username = SA
      Password = Passw0rd
      Database = CardHolders
      Options = -H 192.168.40.15 -P 1433 -V 9
      FetchBufferSize = 99
      ReadOnly = Yes
      DeferLongFetch =
      JetFix = No
      Description = Sample SQLServer 2000 Lite Connection
      MaxRows =
      NoRowSetSizeLimit = No
      InitialSQL =
      NoAutoCommit = No
      NoLoginBox =
      SqlDbmsName =
      QuotedId = Yes
      AnsiNPW = No

      *** initCardHolders.ora
      HS_FDS_CONNECT_INFO=CardHolders
      HS_FDS_TRACE_LEVEL = DEBUG
      HS_FDS_TRACE_FILE_NAME = CardHolders.trc
      HS_FDS_SHAREABLE_NAME = /apex01/oraapex/ODBC_64/lib/sql_mt_lt.so
      HS_FDS_FETCH_ROWS=1
      HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
      HS_FDS_SUPPORT_STATISTICS=FALSE


      *** listener.ora (added)
      (SID_DESC =
      (SID_NAME = CardHolders)
      (ORACLE_HOME= /apex01/oraapex/apexdb/11.2.0.2)
      (PROGRAM = dg4odbc)
      (ENVS=LD_LIBRARY_PATH=/apex01/oraapex/ODBC_64/lib:$ORACLE_HOME/lib)
      )

      *** tnsnames.ora (added)
      CardHolders =
      (DESCRIPTION=
      (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1530))
      (CONNECT_DATA=(SERVICE_NAME=CardHolders))
      (HS=OK)
      )


      Thanks in advance, any help would be appreciated.
      Regards!!
        • 1. Re: Oracle 11R2 TO MSSQLServer via ODBC Hangs
          Kgronau-Oracle
          First issue I saw is the HS_FDS_SHAREABLE_NAME. In your configuration it points to the ODBC driver directly HS_FDS_SHAREABLE_NAME = /apex01/oraapex/ODBC_64/lib/sql_mt_lt.so. The ODBC driver itself looks like it has a couple of basic ODBC functions built in as it fullfills the DG4ODBC check, but it looks like to fails when building the connect string. In general the parameter needs to point to an ODBC driver manager. Openlink is commonly shipping an ODBC driver manager or recommends to use unixODBC - the library is called libodbc.so. Please check if you have installed the ODBC driver manager, then change the configuration.
          It would be also good to see an ODBC trace file to get an idea where the connection is hanging.

          Also please make sure that you can connect with isql (an ODBC test utility) which is commonly shipped with the unixODBC driver manager that you can connect to the SQL Server.

          - Klaus
          • 2. Re: Oracle 11R2 TO MSSQLServer via ODBC Hangs
            723623
            Hi Klaus:

            Thank you for your response.

            I changed the library from sql_mt_lt.so to libodbc.so for HS_FDS_SHAREABLE_NAME as you suggested, restarted all services, but it keeps behaving the sam, it still hangs

            Here is the agent log:
            ------------------------------------------------------------------------------------------------------------------------------------------
            Oracle Corporation --- WEDNESDAY NOV 28 2012 20:03:31.091


            Heterogeneous Agent Release
            11.2.0.2.0




            Oracle Corporation --- WEDNESDAY NOV 28 2012 20:03:31.091

            Version 11.2.0.2.0

            Entered hgogprd
            HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
            Entered hgosdip
            setting HS_OPEN_CURSORS to default of 50
            setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
            setting HS_FDS_RECOVERY_PWD to default value
            setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
            setting HS_IDLE_TIMEOUT to default of 0
            setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
            setting HS_NLS_NCHAR to default of "AL32UTF8"
            setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
            setting HS_FDS_DATE_MAPPING to default of "DATE"
            setting HS_RPC_FETCH_REBLOCKING to default of "ON"
            HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
            setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
            setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
            setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
            setting HS_FDS_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_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
            setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
            setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
            HOSGIP returned value of "32" for HS_FDS_SQLLEN_INTERPRETATION
            setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
            setting HS_FDS_DELAYED_OPEN to default of "TRUE"
            setting HS_FDS_WORKAROUNDS to default of "0"
            Exiting hgosdip, rc=0
            ORACLE_SID is "CardHolders"
            Product-Info:
            Port Rls/Upd:2/0 PrdStat:0
            Agent:Oracle Database Gateway for ODBC
            Facility:hsa
            Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:CardHolders
            Exiting hgogprd, rc=0
            Entered hgoinit
            HOCXU_COMP_CSET=1
            HOCXU_DRV_CSET=31
            HOCXU_DRV_NCHAR=873
            HOCXU_DB_CSET=873
            HS_LANGUAGE is AMERICAN_AMERICA.WE8ISO8859P1
            rc=2147476408 attempting to get LANG environment variable.
            HOCXU_SEM_VER=112000
            Entered hgolofn at 2012/11/28-20:03:31
            HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/apex01/oraapex/ODBC_64/lib/libodbc.so"
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32f1c0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32c6b0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32b420
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a326520
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31cc70
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31a5b0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a337398
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31b5a0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31d1a8
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32fa58
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a325148
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31dcc0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a330328
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a329950
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31e100
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32d458
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31c5d8
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31c198
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32d130
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32fed0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a335e30
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a336d90
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a3101d0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a3179d0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32db00
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a319278
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a31baa8
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a310c38
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a334100
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a334950
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a335780
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a323e58
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a3225c0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a3290d0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a331620
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a30d3e8
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a32a2a8
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a311670
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a311f48
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a312830
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a333820
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a333088
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a335060
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a30e540
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Entered hgolofns at 2012/11/28-20:03:31
            symbol_peflctx=0x7a30eef0
            hoaerr:0
            Exiting hgolofns at 2012/11/28-20:03:31
            Exiting hgolofn, rc=0 at 2012/11/28-20:03:31
            HOSGIP for "HS_OPEN_CURSORS" returned "50"
            HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
            HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
            HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
            HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
            HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
            HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
            HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
            HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
            treat_SQLLEN_as_compiled = 0
            Exiting hgoinit, rc=0 at 2012/11/28-20:03:31
            Entered hgolgon at 2012/11/28-20:03:31
            reco:0, name:SA, tflag:0
            Entered hgosuec at 2012/11/28-20:03:31
            Exiting hgosuec, rc=0 at 2012/11/28-20:03:31
            HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
            HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
            HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
            HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
            HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
            HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
            HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
            HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
            HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
            using SA as default value for "HS_FDS_DEFAULT_OWNER"
            HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
            Entered hgocont at 2012/11/28-20:03:31
            HS_FDS_CONNECT_INFO = "CardHolders"
            HS_FDS_CONNECT_STRING = "192.168.40.15:1433//CardHolders"
            Entered hgogenconstr at 2012/11/28-20:03:31
            dsn:CardHolders, name:SA
            optn:192.168.40.15:1433//CardHolders
            Entered hgocip at 2012/11/28-20:03:31
            dsn:CardHolders
            Exiting hgocip, rc=0 at 2012/11/28-20:03:31
            Exiting hgogenconstr, rc=0 at 2012/11/28-20:03:31

            ---------------------------------------------------------------------------------------------------------------------------------------------------
            An the unixx ODBC trace:

            ** iODBC Trace file
            ** Trace started on Wed Nov 28 20:03:31 2012
            ** Driver Manager: 03.52.0607.1008


            [000000.000313]
            Application 00000001 ENTER SQLAllocHandle
                      SQLSMALLINT 1 (SQL_HANDLE_ENV)
                      SQLHANDLE 0x0 (SQL_NULL_HANDLE)
                      SQLHANDLE * 100362318

            [000000.000335]
            Application 00000001 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
                      SQLSMALLINT 1 (SQL_HANDLE_ENV)
                      SQLHANDLE 0x0 (SQL_NULL_HANDLE)
                      SQLHANDLE * 100362318 (100369a20)

            [000000.000356]
            Application 00000001 ENTER SQLSetEnvAttr
                      SQLHENV 100369a20
                      SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
                      SQLPOINTER 3
                      SQLINTEGER * -6 (SQL_IS_INTEGER)

            [000000.000425]
            Application 00000001 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
                      SQLHENV 100369a20
                      SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
                      SQLPOINTER 3
                      SQLINTEGER * -6 (SQL_IS_INTEGER)

            [000000.000797]
            Application 00000001 ENTER SQLAllocHandle
                      SQLSMALLINT 2 (SQL_HANDLE_DBC)
                      SQLHANDLE 100369a20
                      SQLHANDLE * 100362320

            [000000.000896]
            Application 00000001 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
                      SQLSMALLINT 2 (SQL_HANDLE_DBC)
                      SQLHANDLE 100369a20
                      SQLHANDLE * 100362320 (100369fc0)

            [000000.000933]
            Application 00000001 ENTER SQLSetConnectAttr
                      SQLHDBC 100369fc0
                      SQLINTEGER 102 (SQL_ATTR_AUTOCOMMIT)
                      SQLPOINTER 0x0
                      SQLINTEGER * -5 (SQL_IS_UINTEGER)

            [000000.000981]
            Application 00000001 EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
                      SQLHDBC 100369fc0
                      SQLINTEGER 102 (SQL_ATTR_AUTOCOMMIT)
                      SQLPOINTER 0x0
                      SQLINTEGER * -5 (SQL_IS_UINTEGER)

            [000000.001359]
            Application 00000001 ENTER SQLDriverConnect
                      SQLHDBC 100369fc0
                      SQLPOINTER 0x0
                      SQLCHAR * 100351808
                                | DSN=CardHolders;UID=SA;PWD=******* |
                      SQLSMALLINT 34
                      SQLCHAR * 100350ad0
                      SQLSMALLINT 1024
                      SQLSMALLINT * ffffffff7fffe0b2
                      SQLUSMALLINT 0 (SQL_DRIVER_NOPROMPT)


            Thank you for your time and comments

            Regards!
            • 3. Re: Oracle 11R2 TO MSSQLServer via ODBC Hangs
              Kgronau-Oracle
              it hangs at the connect (when dg4odbc uses the ODBC driver and contacts the foreign database):
              [000000.001359]
              Application 00000001 ENTER SQLDriverConnect
              SQLHDBC 100369fc0
              SQLPOINTER 0x0
              SQLCHAR * 100351808
              DSN=CardHolders;UID=SA;PWD=*******

              Are you able to connect with an ODBC test utility (for example isql) to the SQL Server?
              • 4. Re: Oracle 11R2 TO MSSQLServer via ODBC Hangs
                723623
                Hi Klaus:

                Yes, I can connect from the iODBC Demonstration program that comes with the Openlink installation.

                iODBC Demonstration program
                This program shows an interactive SQL processor
                Driver Manager: 03.52.0507.0105

                Enter ODBC connect string (? shows list): ?

                DSN | Driver
                ------------------------------------------------------------------------------
                CardHolders | OpenLink SQL Server Lite Driver (multi threaded)

                Enter ODBC connect string (? shows list): CardHolders
                Driver: 06.02.1217 OpenLink SQL Server Lite Driver (sql_mt_lt.so)

                SQL>SELECT COUNT(*) FROM sys.master_files;

                EXPR_1
                -----------
                111

                result set 1 returned 1 rows.


                Any other idea?

                Regards!
                • 5. Re: Oracle 11R2 TO MSSQLServer via ODBC Hangs
                  Kgronau-Oracle
                  Could you please post your current gateway init file again - there's a strange entry in the gateway trace I want to check?