创建数据库链接,执行如下脚本:
EXEC sys.sp_addlinkedserver
@server = 'zb',
@srvproduct = N'Oracle',
@provider = N'MSDAORA',
@datasrc = N'PC253'----------------------改
EXEC sys.sp_addlinkedsrvlogin
@rmtsrvname = 'zb', -- sysname
@useself = 'false', -- varchar(8)
@locallogin = NULL, -- sysname
@rmtuser = 'V7HQS_ZY', -- sysname----------改
@rmtpassword = 'rezin' -- sysname---------改
执行脚本测试创建链接是否成功:
SELECT * FROM OPENQUERY(zb,'select * from basvip')
测试成功!