//获取数据库连接字符串(SqlServer2000) Function GetDBConnectionString(IP,DataBaseName,UserName,UserPassWord:String):String; Var DBConnectionString:String; DBTableName:String; ADOConnection_DB:TADOConnection; ADODataSet_DB:TADODataSet; DataSource_DB:TDataSource; Begin DBConnectionString:='Provider=SQLOLEDB.1;Password='+UserPassWord+';Persist Security Info=True'; DBConnectionString:=DBConnectionString+';User ID='+UserName+';Initial Catalog='+DataBaseName+';Data Source='+IP; Result:=DBConnectionString; End;
//连接SQLSERVER2000数据库 Function ConnectDataBase():Boolean; Var DataBaseName,UserName,UserPassWord,IP:String; //定义数据库名、用户名、密码、表名和连接IP Begin IP:=GetIPAddress; //ReadConfig(IniFileName,'DBSet','IP'); //获取计算机IP DataBaseName:=ReadConfig('DBSet','DataBaseName','); //数据库名称 UserName:=ReadConfig('DBSet','UserName','); //数据库用户名称 UserPassWord:=ReadConfig('DBSet','UserPassWord','); //数据库密码 Try With ADOConnection_DB Do Begin LoginPrompt:=False; ConnectionString:=GetDBConnectionString(IP,DataBaseName,UserName,UserPassWord); Connected:=False; Connected:=True; Result:=True; End; Except On E:EOleException Do Begin Result:=False; Beep();Beep(); MessageDLG('Error:'+E.Message,MtWarning,[MBOK],0); End; End; End;