This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Sep 12, 2012 2: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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

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