步骤:
一、右击Linked Servers–>Properties–>add Linked server、Provider、Product name、Data source
二、Security add login and password
三、通过tns配置档连接Oracle数据库
四、用法:
1.select ORGID,ORGANIZATIONNAME,OUID from OPENQUERY(PORTAL_96,'SELECT * FROM DEPTMANAGERS')
2.SELECT DEPT FROM OPENDATASOURCE('SQLOLEDB','DATA SOURCE=IP地址;USER ID=ID名称;Password=密码').[kj_hrm].[dbo].[HR_Dept]