1 2 Previous Next 20 Replies Latest reply: Sep 12, 2012 4:20 AM by Mkirtley-Oracle Go to original post RSS
      • 16. Re: Connect with unixodbc and freetds on 64bit OEL 5.2 to SQL Server 2000.
        367593
        Hello Gurus
        Good evening,

        Here is a situation I am facing,
        I went carefully many times over the steps
        as well trying using ip addresses rather than actual names.....


        Please can you advise.

        Thanks and Regards

        *************************


        1-ERROR MESSAGE
        =============
        10:01:12 Error: ORA-28500:

        2-IN $ORACLE_HOME/hs/admin
        ========================
        initMS_PIMPROD.ora
        #
        # HS init parameters
        #
        HS_FDS_SUPPORT_STATISTICS = FALSE
        HS_FDS_CONNECT_INFO = MS_PIMPROD
        HS_FDS_TRACE_LEVEL = DEBUG
        HS_FDS_TRACE_FILE_NAME = /u01/app/oracle/product/10.2.0/hs/admin/ms_pimprod_trace.trc

        #HS_FDS_SHAREABLE_NAME = /usr/lib/libtdsodbc.so
        HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so
        # ODBC specific environment variables
        set ODBCINI = /export/home/oracle/.odbc.ini
        # Environment variables required for the non-Oracle system
        #
        #set <envvar>=<value>

        3-TRACE FILE
        ==========
        Oracle Corporation --- WEDNESDAY MAY 05 2010 10:11:31.753
        Version 10.2.0.3.0
        hoagprd (2): ; hoagprd Entered.
        HOACONN.C (244): ; [Generic Connectivity Using ODBC] version: 4.8.2.0.0080
        HOACONN.C (288): ; Class version: 250
        hoagprd (2): ; hoagprd Exited with retcode = 0.
        hoainit (3): ; hoainit Entered.
        (0): ; connect string is: defTdpName=MS_PIMPROD;SYNTAX=(ORACLE8_HOA, BASED_ON=
        ORACLE8, IDENTIFIER_QUOTE_CHAR="", CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);
        BINDING=<navobj><binding><datasources><datasource name='MS_PIMPROD' type='
        GENERIC_ODBC_FOR_HS' connect='MS_PIMPROD'><driverProperties/></datasource></
        datasources><remoteMachines/><environment><optimizer noFlattener='true'/><misc
        year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
        parserDepth='2000' tokenSize='1000' noInsertParameterization='true'
        noThreadedReadAhead='true' noCommandReuse='true'/><debug generalTrace='true'/>
        </environment></binding></navobj>
        ORACLE GENERIC GATEWAY Log File Started at 2010-05-05T10:11:31

        hoainit (3): ; hoainit Exited with retcode = 0.
        hoalgon (7): ; hoalgon Entered. name = pimoraclelink.
        errors.h (2098): ; [unixODBC][Driver Manager]Can't open lib '/usr/lib/
        libtdsodbc.so' : libodbcinst.so.1: cannot open shared object file: No such
        file or directory (SQL State: 01000; SQL Code: 0)
        DRV_InitTdp: errors.h (2098): ; [unixODBC][Driver Manager]Can't open lib '/usr/
        lib/libtdsodbc.so' : libodbcinst.so.1: cannot open shared object file: No such
        file or directory (SQL State: 01000; SQL Code: 0)

        nvRETURN (./drv_bind.c 356): -2220
        nvRETURN (./nav_bind.c 298): -2220
        hoalgon (7): ; hoalgon Exited with retcode = 28500.
        hoaexit (6): ; hoaexit Entered.
        hoaexit (6): ; hoaexit Exited with retcode = 0.
        (0): ; Closing log file at WED MAY 5 10:11:31 2010.

        4-Environment
        TDSVER=8.0
        export TDSVER
        SHLIB_PATH=/usr/lib
        export SHLIB_PATH
        LD_LIBRARY_PATH=$ORACLE_HOME/lib
        export LD_LIBRARY_PATH
        LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib
        export LD_LIBRARY_PATH
        ODBCSYSINI=/etc
        export ODBCSYSINI
        export ODBCINI=/export/home/oracle/.odbc.ini

        5-LIBRARY PATH
        echo $LD_LIBRARY_PATH
        /u01/app/oracle/product/10.2.0/lib:/usr/lib

        6-ODBC LINK
        cat /etc/odbc.ini
        [MS_PIMPROD]
        Driver = FreeTDS
        Description = ODBC connection via UnixOdbc
        Trace = No
        Server = Sqlservercluster\Sqlserverinstance
        Database = PIM
        Port = 1433


        ]$cat /etc/odbcinst.ini
        [FreeTDS]
        Description = v.063
        Driver = /usr/lib/libtdsodbc.so
        Setup = /usr/lib/libtdsodbc.so
        CPTimeout =
        CPReuse =
        FileUsage = 1

        $isql -v MS_MSPIMPROD user passwd
        ---------------------------------------
        | Connected! |
        | |
        | sql-statement |
        | help [tablename] |
        | quit |
        | |
        ---------------------------------------
        7-Drivers
        $ls -lt libodbc.so*
        -rw-r--r-- 1 root root 426436 May 5 10:07 libodbc.so.1.0.0
        -rw-r--r-- 1 root root 426436 May 5 10:06 libodbc.so.1
        -rw-r--r-- 1 root root 426436 May 5 10:06 libodbc.so


        8-LISTENER
        LISTENER =
        (DESCRIPTION_LIST =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        (ADDRESS = (PROTOCOL = TCP)(HOST = server50.hpmg.com)(PORT = 1521))
        )

        *****
        )
        (SID_DESC=
        (SID_NAME=MS_PIMPROD)
        (ORACLE_HOME=/u01/app/oracle/product/10.2.0)
        (PROGRAM=hsodbc)
        (ENVS=LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/lib:/usr/lib)
        )

        9-TNSNAMES
        MS_PIMPROD.HPMG.COM =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = server50.hpmg.com)(PORT = 1521))
        (CONNECT_DATA =( SID = MS_PIMPROD))
        (HS = OK)
        )

        10-RECREATING LINKS
        CREATE PUBLIC DATABASE LINK "MS_PIMPROD.HPMG.COM"
        CONNECT TO "pimoraclelink"
        IDENTIFIED BY <PWD>
        USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
        (HOST = server50.hpmg.com)(PORT = 1521))
        (CONNECT_DATA = (SID = MS_PIMPROD))(HS = OK))';

        Little bit More infos
        =====================
        A-re-installed Free-tds
        B-rebuild caths.sql
        connect fine from linux
        Unfortunately I still have the ora-28500 error. Where my mistake?
        • 17. Re: Connect with unixodbc and freetds on 64bit OEL 5.2 to SQL Server 2000.
          367593
          Some more information
          ===============
          Os info:     Linux dw-50.primed.com 2.6.18-164.15.1.el5PAE #1 SMP Mon Mar 1 11:14:09 EST 2010 i686 i686 i386 GNU/Linux
          Oracle info:     10.2
          Sql server: 2000/2005/2008

          Error info:     10:01:12 Error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
          [Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE (819): ; [C078] Dynamic library '/usr/lib/libodbc.so' was not found
          ORA-02063: preceding 2 lines from MS_PIMPROD
          • 18. Re: Connect with unixodbc and freetds on 64bit OEL 5.2 to SQL Server 2000.
            367593
            Good news
            I removed all...and start from step one. using "the stable" freetds
            then make sure that I have the proper link for libodbc.so:
            ln -s /usr/local/lib/libodbc.so.1.0.0 /usr/lib/libodbc.so
            everything is working fine now.
            • 19. Connect SQL Server 2008 database from oracle
              928943
              i want to connect sql server database from oracle 11g.

              oracle 11(g)
              -64 bit
              -linux (oel) 64bit

              Sql serevr 2008
              -windows server 2003
              -64 bit
              these on the same network.please help me how to connect it
              • 20. Re: Connect SQL Server 2008 database from oracle
                Mkirtley-Oracle
                Hi,
                It is always better to ask a question like this in a new thread instead of adding to an existing one qwhich has been resolved. Very often upddates like this can be missed.
                However, to connect from Oracle 11g to SQL*Server you can use one of the Oracle gateway products.
                You coudl use either -

                Database gateway for SQL*Server
                or
                Database Gateway for ODBC

                The following notes in My Oracle Support have further information and discuss the differences between the 2 gateways -

                Master Note for Oracle Gateway Products (Doc ID 1083703.1)

                Options for Connecting to Foreign Data Stores and Non-Oracle Databases (Doc ID 233876.1)
                Functional Differences Between DG4ODBC and Specific Database Gateways (Doc ID 252364.1)
                Gateway and Generic Connectivity Licensing Considerations (Doc ID 232482.1)

                Please review this information and get back if you have any further questions, but as said, it would be btter to ask these in a new thread.

                Regards,
                Mike
                1 2 Previous Next