Database Link to SQL Server without using listener.ora
DBAsupport.com 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
    Posts
    1

    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)(HOST=servername.ca.blah.com)(PORT=1521))(CONNECT_DATA=(SID=DB2 ))(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
    SQLServer.sea.ca.blah.com =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)
    (Host = ora-dqnw-001.nw.nos.blah.com)
    (Port = 1521))
    (CONNECT_DATA = (SID = SQLServer))
    (HS=OK)
    )
    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
    Posts
    736
    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