procedure TForm1.FormCreate(Sender: TObject);
var
Fini:Tinifile;
sql:string;
filename:string;
constring:string;
begin
filename:=ExtractFilePath(Paramstr (0))+'serverip.ini';
Fini:=TiniFile.create(filename);
with Fini do
try
sql:=Fini.readstring('server', 'ip', '');//ip是192.168.1.11
finally
Fini.destroy;
end;
constring:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=building;
Data Source='''+sql+'''';
adoconnection1.ConnectionString:=constring;
adoconnection1.open;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
if adoconnection1.Connected=true then
showmessage('1')
else
showmessage('2');
form2.show;
end;
请问上面代码错在哪?我是想如果连接失败的话,进入form2,写INI。
var
Fini:Tinifile;
sql:string;
filename:string;
constring:string;
begin
filename:=ExtractFilePath(Paramstr (0))+'serverip.ini';
Fini:=TiniFile.create(filename);
with Fini do
try
sql:=Fini.readstring('server', 'ip', '');//ip是192.168.1.11
finally
Fini.destroy;
end;
constring:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=building;
Data Source='''+sql+'''';
adoconnection1.ConnectionString:=constring;
adoconnection1.open;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
if adoconnection1.Connected=true then
showmessage('1')
else
showmessage('2');
form2.show;
end;
请问上面代码错在哪?我是想如果连接失败的话,进入form2,写INI。
connection.open;
except
form2.showmodal;
end;
except
end;如果要最准确的话可以onerror
2.adoconnection1.open;你在oncreate事件中已经打开,如果连不上会有错误提示.
3.可以把这句去掉,在button1中联接数据库就行.
showmessage('1')
else
showmessage('2');
form2.show;
end;
改成
if adoconnection1.Connected=true then
showmessage('1')
else
begin
showmessage('2');
form2.show;
end;
end;