sql server 2000的查询分析器中查询网络驱动器(映射的硬盘)的dbf数据库表,文件不存在,而如果不是网络驱动器就好使?
1.select * from openrowset
('MSDASQL','PWD=;SourceType=DBF;UID=;Collate=Machine;Deleted=Yes;BackgroundFetch=Yes;Exclusive=No;
Driver=Microsoft Visual FoxPro Driver;Null=Yes;SourceDB=C:\','select * from 0401010531.dbf') 这个是成功的。2.select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=\\192.168.1.12\data\;UID=;PWD=;Null=Yes;Collate=Machine;BackgroundFetch=Yes;Exclusive=No;',
'select * from 0401010531.dbf')
或者
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=Z:\;UID=;PWD=;Null=Yes;Collate=Machine;BackgroundFetch=Yes;Exclusive=No;',
'select * from 0401010531.dbf')
都是失败的。那位高人遇到过此问题请赐教,已经困扰好几天了。
1.select * from openrowset
('MSDASQL','PWD=;SourceType=DBF;UID=;Collate=Machine;Deleted=Yes;BackgroundFetch=Yes;Exclusive=No;
Driver=Microsoft Visual FoxPro Driver;Null=Yes;SourceDB=C:\','select * from 0401010531.dbf') 这个是成功的。2.select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=\\192.168.1.12\data\;UID=;PWD=;Null=Yes;Collate=Machine;BackgroundFetch=Yes;Exclusive=No;',
'select * from 0401010531.dbf')
或者
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=Z:\;UID=;PWD=;Null=Yes;Collate=Machine;BackgroundFetch=Yes;Exclusive=No;',
'select * from 0401010531.dbf')
都是失败的。那位高人遇到过此问题请赐教,已经困扰好几天了。
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=192.168.1.12\data;UID=;PWD=;Null=Yes;Collate=Machine;BackgroundFetch=Yes;Exclusive=No;',
'select * from 0401010531.dbf')data目录要共享