可以使用odbc连接,也可以通过bde
可以参考一下的程序再程序中动态配置odbc,例子中用的是access,可以首先在本机上配置一个连接到dbf的odbc数据源,然后参考注册表中相应选项是怎么写的,然后修改程序就可以了。 with TRegistry.Create do
begin
RootKey:=HKEY_LOCAL_MACHINE;
openKey('\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)',true);
SqlDriver:=readstring('Driver');
closekey;
OpenKey('\Software\ODBC\ODBC.INI\ODBC Data Sources',true);
WriteString('WebRooter','Microsoft Access Driver (*.mdb)');
closekey;
OpenKey('\Software\ODBC\ODBC.INI\WebRooter',True);
WriteString('DBQ',ExtractFilePath(Application.ExeName)+'WebRooter.mdb');
WriteString('Driver',SqlDriver);
WriteString('FIL','MS Access;');
WriteString('UID','UID');
WriteInteger('DriverId',25);
WriteInteger('SafeTransactions',0);
closekey;
OpenKey('\Software\ODBC\ODBC.INI\WebRooter\Engines',True);
closekey;
OpenKey('\Software\ODBC\ODBC.INI\WebRooter\Engines\Jet',True);
WriteString('ImplicitCommitSync','');
WriteInteger('MaxBufferSize',2048);
WriteInteger('PageTimeout',5);
WriteInteger('Threads',3);
WriteString('UserCommitSync','Yes');
closekey;
free;
end;
可以参考一下的程序再程序中动态配置odbc,例子中用的是access,可以首先在本机上配置一个连接到dbf的odbc数据源,然后参考注册表中相应选项是怎么写的,然后修改程序就可以了。 with TRegistry.Create do
begin
RootKey:=HKEY_LOCAL_MACHINE;
openKey('\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)',true);
SqlDriver:=readstring('Driver');
closekey;
OpenKey('\Software\ODBC\ODBC.INI\ODBC Data Sources',true);
WriteString('WebRooter','Microsoft Access Driver (*.mdb)');
closekey;
OpenKey('\Software\ODBC\ODBC.INI\WebRooter',True);
WriteString('DBQ',ExtractFilePath(Application.ExeName)+'WebRooter.mdb');
WriteString('Driver',SqlDriver);
WriteString('FIL','MS Access;');
WriteString('UID','UID');
WriteInteger('DriverId',25);
WriteInteger('SafeTransactions',0);
closekey;
OpenKey('\Software\ODBC\ODBC.INI\WebRooter\Engines',True);
closekey;
OpenKey('\Software\ODBC\ODBC.INI\WebRooter\Engines\Jet',True);
WriteString('ImplicitCommitSync','');
WriteInteger('MaxBufferSize',2048);
WriteInteger('PageTimeout',5);
WriteInteger('Threads',3);
WriteString('UserCommitSync','Yes');
closekey;
free;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货