procedure TDM_DataBase.DataModuleCreate(Sender: TObject); Var ConStr,PassWord,UID,DBName,ServerName:String; IniFile:TIniFile; begin //*****************************************************************// {从INI配置文件读取数据库连接设置} {Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Lxgd;Data Source=TY-024} //*****************************************************************// IniFile:=TInifile.Create(G_IniPath); ServerName := IniFile.ReadString('DBConStr','ServerName',''); DBName := IniFile.ReadString('DBConStr','DBName','LXGD'); UID := IniFile.ReadString('DBConStr','UID','sa'); PassWord := IniFile.ReadString('DBConStr','PassWord',''); PassWord := Decryptstr(PassWord,G_Key); IniFile.Free; if (Trim(ServerName)='') or (Trim(DBName)='') or (Trim(UID)='') or (PassWord='') then begin MessageBox(Application.handle,PChar('数据库连接配置不正确或未配置,请先配置数据库连接!'),PChar('提示'),0); if not Assigned(Frm_DataBaseSet) then Application.CreateForm(TFrm_DataBaseSet,Frm_DataBaseSet); Frm_DataBaseSet.ShowModal; end else begin //*****************{以下是连接数据库}**************************// ConStr:='Provider=SQLOLEDB.1;Password='+PassWord+ ';Persist Security Info=True;User ID='+UID+ ';Initial Catalog='+DBName+ ';Data Source='+ServerName; ADOCon.ConnectionString:=ConStr; Try ADOCon.Connected:=True; Except on EOleException do begin MessageBox(Application.handle,PChar('数据库连接失败,请重新配置数据库连接!'),PChar('提示'),0); if not Assigned(Frm_DataBaseSet) then Application.CreateForm(TFrm_DataBaseSet,Frm_DataBaseSet); Frm_DataBaseSet.ShowModal; end; end; end; end;
邮箱:[email protected]可以额外加分
Var
ConStr,PassWord,UID,DBName,ServerName:String;
IniFile:TIniFile;
begin
//*****************************************************************//
{从INI配置文件读取数据库连接设置}
{Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Lxgd;Data Source=TY-024}
//*****************************************************************//
IniFile:=TInifile.Create(G_IniPath);
ServerName := IniFile.ReadString('DBConStr','ServerName','');
DBName := IniFile.ReadString('DBConStr','DBName','LXGD');
UID := IniFile.ReadString('DBConStr','UID','sa');
PassWord := IniFile.ReadString('DBConStr','PassWord','');
PassWord := Decryptstr(PassWord,G_Key);
IniFile.Free;
if (Trim(ServerName)='') or (Trim(DBName)='') or (Trim(UID)='') or (PassWord='') then
begin
MessageBox(Application.handle,PChar('数据库连接配置不正确或未配置,请先配置数据库连接!'),PChar('提示'),0);
if not Assigned(Frm_DataBaseSet) then
Application.CreateForm(TFrm_DataBaseSet,Frm_DataBaseSet);
Frm_DataBaseSet.ShowModal;
end else
begin
//*****************{以下是连接数据库}**************************//
ConStr:='Provider=SQLOLEDB.1;Password='+PassWord+
';Persist Security Info=True;User ID='+UID+
';Initial Catalog='+DBName+
';Data Source='+ServerName;
ADOCon.ConnectionString:=ConStr;
Try
ADOCon.Connected:=True;
Except
on EOleException do
begin
MessageBox(Application.handle,PChar('数据库连接失败,请重新配置数据库连接!'),PChar('提示'),0);
if not Assigned(Frm_DataBaseSet) then
Application.CreateForm(TFrm_DataBaseSet,Frm_DataBaseSet);
Frm_DataBaseSet.ShowModal;
end;
end;
end;
end;
ServerName=192.2.2.84
DBName=LXGD
UID=sa
PassWord=7062
配置文件是这样的.连接不成功时ShowModal配置Form