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

kite98 2001-11-22 04:42:05
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.]

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


...全文
48 点赞 收藏 5
写回复
5 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
bluebill 2002-01-22
我也在做类似的东西
回复
chen_yj 2001-11-23
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.]

回复
kite98 2001-11-23
还是不行,谁知道?
回复
lcooky 2001-11-22
你没有权限访问那台机子,首先访问一下就可以了
回复
Amoon 2001-11-22
你的机器要是服务器端
回复
相关推荐
发帖

1188

社区成员

VB 数据库(包含打印,安装,报表)
申请成为版主
帖子事件
创建了帖子
2001-11-22 04:42
社区公告
暂无公告