M
malaya
Unregistered / Unconfirmed
GUEST, unregistred user!
98下使用SELECT语句无法查询DBF,提示无法找到可用的数据源,却可以用INSERT语句插入数据,在XP下查询,插入均可实现,不知是什么原因,哪位大侠可以指点一二,感激之情,不胜言表..........
源代码如下:
adoconnection3.Connected:=false;
adoconnection3.ConnectionString:=' Provider=MSDASQL.1;Persist Security Info=False;Connect Timeout=15;Extended Properties="Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=e:/;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=;Null=Yes;Deleted=Yes;";Locale Identifier=2052';
adoconnection3.Connected:=true;
with adoquery3 do
begin
close;
sql.clear;
sql.Add('select * from resource') ;
open;
last;
end;
源代码如下:
adoconnection3.Connected:=false;
adoconnection3.ConnectionString:=' Provider=MSDASQL.1;Persist Security Info=False;Connect Timeout=15;Extended Properties="Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=e:/;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=;Null=Yes;Deleted=Yes;";Locale Identifier=2052';
adoconnection3.Connected:=true;
with adoquery3 do
begin
close;
sql.clear;
sql.Add('select * from resource') ;
open;
last;
end;