请教在sql 中运行分布式数据库的问题

[kite98]

EXEC sp_addlinkedserver
@server = 'SEATTLEMk',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\ddd\d\8.12access\data.mdb'
GO
EXEC sp_addlinkedsrvlogin 'SEATTLEMk'

Select a.* from OPENrowset(SEATTLEMk, 'Select * from rdrecord') as a
报错：Could not open table 'SEATTLEMk' from OLE DB provider 'SQL Server'.

SELECT * From OpenRowset('Microsoft.Jet.OLEDB.4.0','\\[ddd]\d\812access\data.mdb'; 'admin';'', rdrecord)

报错：OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: '\\ddd\812access\ufdata.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.]

在查询分析器中运行。我该怎么办？

[Amoon]

你的机器要是服务器端

• 打赏
• 举报

回复 赞

[lcooky]

你没有权限访问那台机子，首先访问一下就可以了

• 打赏
• 举报

回复 赞

[kite98]

还是不行，谁知道？

• 打赏
• 举报

回复 赞

[chen_yj]

OLE/DB provider returned message: '\\ddd\812access\ufdata.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.]

• 打赏
• 举报

回复 赞

[bluebill]

我也在做类似的东西

• 打赏
• 举报

回复 赞