从oracle到sas的一个问题？

shiyiming

proc sql;  
   connect to oracle as myconn (user=user password=password   
      path='??????');  
   disconnect from myconn;  
quit;  
  
what should the path be? How can I find this paramenter's value?  
  
多谢大侠相助！

shiyiming

path 为Oracle Net Manager下配置的服务命名。
如有问题，请联系本人。

shiyiming

找到你的oracel中的tnsnames.ora文件，如C:\oracle\ora92\network\admin\tnsnames.ora，打开它
[code:7a3ec]......
TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dwh)
    )
  )
......[/code:7a3ec]
[quote:7a3ec]SERVICE_NAME = [color=red:7a3ec]dwh[/color:7a3ec][/quote:7a3ec]就是你要找的。