I am trying to set up heterogenous service on Linux to MSSQL and I have the question:
(PROTOCOL = tcp)(HOST = oracle_host)(PORT = 1521))
(SID = msql) – match with ODBC source name and SID in listenner.ora
(HS = OK)
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle_host)(PORT = 1521))
(SID_NAME=msql) -- match with SID in tnsnames.ora
(PROGRAM=hsodbc) -- hsodbc is an executable
About the SID name, I unsderstand that the SID name has to be the same between TNSNAMES and LISTENER.ora; however, where do we get this SID NAME ????
Was it suppose to be the same with the SID name where you are going to create the link on later????
Click Here to Expand Forum to Full Width