Database Link to SQL Server without using listener.ora Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Database Link to SQL Server without using listener.ora

  1. #1
    Join Date
    Sep 2004

    Database Link to SQL Server without using listener.ora

    I am trying to create a database link to a SQL Server database but all the data I have read indicates that I must have one entry in both the listener.ora and tnsnames.ora files.

    I know that I can create a database link containing the tnsnames information and bypass the need for another entry in the tnsnames file like this connection to db2: create public database link DB2 connect to "nunya" identified by "nunya" using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)( ))(HS=))'; But I cannot figure out what the information should be for SQL Server.

    FYI I already have tried the below method, but would like to bypass the need for tnsnames and listener.

    Currently I have the following entry in the tnsnames file =
    (Host =
    (Port = 1521))
    (CONNECT_DATA = (SID = SQLServer))
    and this entry in the listener.ora file
    (SID_DESC =
    (SID_NAME = SQLServer)
    (ORACLE_HOME = F:\ORA_817)
    (PROGRAM = hsodbc)

    The database link then references rms_cms. This works just fine.

  2. #2
    Join Date
    May 2001
    Another way to connect is by using ODBC.In this way u can by pass the Listener.But I don't why the listener is coming into picture as we use to connect to DB2 environment only modifications required are in TNSNAMES.ORA which is a must this u can't by pass.

Posting Permissions

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

Click Here to Expand Forum to Full Width