oracle数据库中 创建连接sqlserver 查询时出现 连接关闭
0
悬赏园豆：10
[待解决问题]
create public database link Sheng
connect to test identified by testpwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.243)(PORT =1433))
)
(CONNECT_DATA =
(SERVICE_NAME = eCell6)
)
)';
select * from USERS@Sheng;
查询时出现 连接关闭
所有回答(1)
0
oracle通过dblink连接sqlserver确实没有用到过，不过，我找了个网址，你可以参考一下。http://bxl766.blog.163.com/blog/static/6109950520128101055379/
