我在Query Analyzer里执行如下的可以通过,我连接到我们的服务器,JCQ是我的计算机名,C是我的共享名:
select a.* from
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\JCQ\C\NWIND.MDB';'Admin';'', Orders) as a
select a.* from
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\JCQ\C\NWIND.MDB';'Admin';'', Orders) as a
服务器: 消息 7399,级别 16,状态 1,行 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: 'C:\windows\desktop\northwind.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.]
改成\\JCQ\\C\\NWIND.MDB'试试。