è¿æ¥æå¡å¨
linkedserver
sp_addlinkedserver [ @server = ] 'server'
[ , [ @srvproduct = ] 'product_name' ]
[ , [ @provider = ] 'provider_name' ]
[ , [ @datasrc = ] 'data_source' ]
[ , [ @location = ] 'location' ]
[ , [ @provstr = ] 'provider_string' ]
[ , [ @catalog = ] 'catalog' ]
C. 使ç¨ç¨äº Oracle ç Microsoft OLE DB æä¾ç¨åº
æ¤ç¤ºä¾å建ä¸å°å为 LONDON Mktg çé¾æ¥æå¡å¨ï¼è¯¥æå¡å¨ä½¿ç¨ç¨äº Oracle ç Microsoft OLE DB æä¾ç¨åºï¼å¹¶ä¸åè®¾æ¤ Oracle æ°æ®åºç SQL*Net å«å为 MyServerã
USE master
GO
-- To use named parameters:
EXEC sp_addlinkedserver
@server = 'LONDON Mktg',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'MyServer'
GO
-- OR to use no named parameters:
USE master
GO
EXEC sp_addlinkedserver
'LONDON Mktg',
'Oracle',
'MSDAORA',
'MyServer'
GO
温馨提示:答案为网友推荐,仅供参考