SQL Server 2005 连接Oracle(Link Server)

1. 正确配置tnsname.ora文件

2.配置ODBC數據源

3.

exec sp_addlinkedserver

@server='orcl_link',

@srvproduct='Oracle',

@provider='MSDAORA',

@datasrc='orcl'

4.

exec sp_addlinkedsrvlogin

@rmtsrvname='orcl_link',

@useself='false',

@locallogin='sa',

@rmtuser='adammes',

@rmtpassword='password'

5.

select * from openquery(orcl_link,'select * from adammes.tb01')

转载于:https://www.cnblogs.com/adamw/archive/2010/12/21/1913088.html