AdOLinkSQLServerStr = 'Provider=SQLOLEDB.1;Password=%s'+
';Persist Security Info=True;User ID=%s'+
';Initial Catalog=%s'+
';Data Source=%s'+
';Use Procedure for Prepare=1;Auto Translate=True;'+
'Packet Size=4096;Use Encryption for Data=False;'+
'Tag with column collation when possible=False';
procedure TBillApplicationServer.InitConnection;
var
ini: TIniFile;
sPath,sType: string;
begin
sPath:=ExtractFilePath(getLibDir);
ini := TIniFile.Create(sPath+'jfSvr.ini');
try
try
if MainConnection.Connected then MainConnection.Close;
sType:=ini.ReadString('Database','Type','');
MainConnection.ConnectionString:=Format(AdOLinkSQLServerStr,
[ini.ReadString('Database','SPassWord',''),ini.ReadString('Database','SUserID',''),
ini.ReadString('Database','SCatalog',''),ini.ReadString('Database','SAddress','')])
MainConnection.Open;
sDebugFileName:=ini.ReadString('Debug','DebugFileName','');
bDebug:=sDebugFileName<>'';
except
on E: Exception do WriteDebugLog(E.Message);
end;
finally
ini.Free;
end;