uses inifiles;
var inifile:tinifile;
strconnection:string;//数据库连接字符串
inifile:=tinifile.Create('c:\information.ini');//打开ini文件
//读出ini文件的数据库配置信息
strconnection:='Provider='+inifile.Readstring('数据库连接','Provider','')+';';
strconnection:=strconnection+'Persist Security Info='+ inifile.Readstring('数据库连接','Persist Security Info','')+';';
strconnection:=strconnection+ 'User ID='+inifile.Readstring('数据库连接','User ID','sa')+';';
strconnection:=strconnection+ 'Initial Catalog='+ inifile.Readstring('数据库连接','Initial Catalog','')+';';
if inifile.Readstring('数据库连接','Data Source','')<>'' then
strconnection:=strconnection+ 'Data Source='+ inifile.Readstring('数据库连接','Data Source','')+';';
strconnection:=strconnection+ 'Locale Identifier='+ inifile.Readstring('数据库连接','Locale Identifier','2052')+';';
strconnection:=strconnection+ 'Connect Timeout='+ inifile.Readstring('数据库连接','Connect Timeout','15')+';';
strconnection:=strconnection+ 'Use Procedure for Prepare='+ inifile.Readstring('数据库连接','Use Procedure for Prepare','1')+';';
strconnection:=strconnection+ 'Auto Translate='+inifile.Readstring('数据库连接','Auto Translate','')+';';
strconnection:=strconnection+ 'Packet Size='+inifile.Readstring('数据库连接','Packet Size','4096')+';';
strconnection:=strconnection+ 'Workstation ID='+inifile.Readstring('数据库连接','Workstation ID','');
//连接数据库
with ADOConnection1 do
begin
Connected:=false;
ConnectionString:=strconnection;
try
connected:=true;
except
application.MessageBox('数据库联接错误!请执行数据库联接程序。','物业管理',MB_ICONERROR+mb_ok);
application.Terminate;//退出程序
end; //end try
end;//end with
下面是ini文件结构
[数据库连接]
Provider=SQLOLEDB.1
Persist Security Info=False
User ID=sa
Initial Catalog=此处填写需要连接的数据库的名字
Data Source=此处填写数据库所在的机器名字
Locale Identifier=2052
Connect TimeOut=10
Use Procedure for Prepare=1
Auto Translate=True
Packet Size=4096