首先在192.0.0.1中企业管理器中加一个Linked Servers. 在存储过程这样调用即可: select * from [192.0.0.2].db2.dbo.table2
谢谢stonegem001等人。 但我建立连接服务器,然后用开放查询语言时发现,用select语句可以,但用update,insert等修改语句就报错。不知道怎么回事? 错误如下:(我是用一简单的update语句做实验的,用相应select语句却没报错) Server: Msg 7306, Level 16, State 2, Line 1 Could not open table 'db2"."dbo"."table2"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements. [OLE/DB provider returned message: 多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成。]
在存储过程这样调用即可:
select * from [192.0.0.2].db2.dbo.table2
但我建立连接服务器,然后用开放查询语言时发现,用select语句可以,但用update,insert等修改语句就报错。不知道怎么回事?
错误如下:(我是用一简单的update语句做实验的,用相应select语句却没报错)
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table 'db2"."dbo"."table2"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements.
[OLE/DB provider returned message: 多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成。]