测试环境:
SQL Server 2005+oracle10g client
oracle版本: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
1.在Net Manager中添加一个Server Naming:oaktest
2.连接到SQL Server 2005:
开始-->程序-->Microsoft SQL Server 2005-->SQL Server Management Studio-->连接到Databas Engine.
3.新增Linked Server:sqltoora
Server Objects-->Linked Servers,在Linked Servers点右键,新增Linked Serve
Liked server:在SQL Server访问oracle使用的字符串,自己定义,如:sqltoora
Server type:选择Other data source
provider:选择Microsoft OLE DB Provider for Oracle
Product name:不允许为空,自己定义,如:ora10g
Data source:输入第一步中定义的Server Naming oaktest
Provider string:输入 MSDAORA
在Security标签,选择Be made using this security context
Remote login:要访问oracle数据库的用户名
with password:oracle数据库用户的密码
4.访问测试
select * from openquery(sqltoora, 'select * from oak.areas')
查询结果如下:
radius area
7 153.94
8 201.06
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7419833/viewspace-617400/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7419833/viewspace-617400/