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
(ADDRESS = (PROTOCOL = TCP)
(Host = ora-dqnw-001.nw.nos.blah.com)
(Port = 1521))
(CONNECT_DATA = (SID = SQLServer))
and this entry in the listener.ora file
(SID_NAME = SQLServer)
(ORACLE_HOME = F:\ORA_817)
(PROGRAM = hsodbc)
The database link then references rms_cms. This works just fine.
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.
Click Here to Expand Forum to Full Width