Results 1 to 2 of 2

Thread: Link to SQL2000

  1. #1
    Join Date
    Jan 2004
    Posts
    13

    Unanswered: Link to SQL2000

    Hi, I am trying to set up a link from oracle 8.1.7 to sql2000 on different win2000 servers.

    I have set up an ODBC connection and if I test this with MS Access on same machine as Oracle server I am able to link to tables on SQL server.
    This ODBC connection only works if I use port 1433.

    Then I edited tnsnames.ora & listener.ora in Oracle_Home/network/admin

    192.168.15.7 is ip of sql machine and redrouter is sql sid name, when i try tnsping I get:
    TNS-1254: TNS:no listener



    ODS1SERVER =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.34)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ods1)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = ODS2)
    (PRESENTATION = http://admin)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ODS2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ODS2)
    )
    )

    REDROUTER =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.7)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = redrouter)
    )
    (HS = OK)
    )




    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ODS2)
    (ORACLE_HOME = D:\oracle\ora81)
    (SID_NAME = ODS2)
    )
    (SID_DESC =
    (SID_NAME = redrouter)
    (ORACLE_HOME = D:\oracle\ora81)
    (PROGRAM=hsodbc)
    )
    )

    Any help?? Do I need to have SQL2000 client installed on Oracle Server machine??

  2. #2
    Join Date
    Jan 2004
    Posts
    13
    Problem was solved. For details see: http://forums.oracle.com/forums/thre...t=0&msRange=15

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •