if data.cn.Connected=false then try data.cn.ConnectionString:=''; if data.database.Caption='access' then data.cn.ConnectionString:='DBQ='+edit1.Text+'SUPERVISE.MDB;DefaultDir='+data.server.Caption+';Driver={Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;password=21233382135761;UserCommitSync=Yes'; if data.database.Caption='sql server' then data.cn.ConnectionString:='Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DRIVER=SQL Server;SERVER='+edit1.Text+';UID='+edit2.Text+';PWD='+edit3.Text+';DATABASE=NHII"'; data.cn.Connected:=true; except showmessage('数据与服务器连接不正常,请检查服务器设置!'); Panel1.visible:=false; panl.visible:=true; exit; end;
try
adoconnection1.connected:=true;//或者adoconnection1.open;
except
showmessage('error');
end;
try
data.cn.ConnectionString:='';
if data.database.Caption='access' then data.cn.ConnectionString:='DBQ='+edit1.Text+'SUPERVISE.MDB;DefaultDir='+data.server.Caption+';Driver={Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;password=21233382135761;UserCommitSync=Yes';
if data.database.Caption='sql server' then data.cn.ConnectionString:='Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DRIVER=SQL Server;SERVER='+edit1.Text+';UID='+edit2.Text+';PWD='+edit3.Text+';DATABASE=NHII"';
data.cn.Connected:=true;
except
showmessage('数据与服务器连接不正常,请检查服务器设置!');
Panel1.visible:=false;
panl.visible:=true;
exit;
end;
问题就搞定
在这里做判断可以吗
sorry