请教在sql 中运行分布式数据库的问题
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.]
在查询分析器中运行。我该怎么办?