Zeoslib Portal

hi...
is there any event for detect if sometime connection lost,..
i'm using zeos 7 and mysql.

try this it worked for me

try
DM.Zeos.Connected := False;
DM.Zeos.HostName := mysql_hostname;
DM.Zeos.Protocol := 'mysql-5';
DM.Zeos.Database := mysql_database;
DM.Zeos.user := mysql_username;
DM.Zeos.Password := mysql_password;
DM.Zeos.Connected := true;
Except
On E: Exception do
begin
MessageDlg('Cannot connect to database "' + mysql_hostname + '"!.' + #13 + #10 + 'Please contact your system adminsitrator.', mtError, [mbOK], 0);
end;
end;

meltoywerks wrote:try this it worked for me

try
DM.Zeos.Connected := False;
DM.Zeos.HostName := mysql_hostname;
DM.Zeos.Protocol := 'mysql-5';
DM.Zeos.Database := mysql_database;
DM.Zeos.user := mysql_username;
DM.Zeos.Password := mysql_password;
DM.Zeos.Connected := true;
Except
On E: Exception do
begin
MessageDlg('Cannot connect to database "' + mysql_hostname + '"!.' + #13 + #10 + 'Please contact your system adminsitrator.', mtError, [mbOK], 0);
end;
end;

no, i mean notify if successfully connection got lost unexpected, your code will drop the connection, on idle thats maybe usefull, but if on edit, it will lost data...
i have figure it out with function ping or pingserver...
what i wanted if there any event if connection lost, like unidac, event onlostconnection...
now i have been using thread to monitor connection every few second, lot of time to create syncronizing method on all interface because annoying invalid window handle..
but nevermind i have done...

thanks for reply...

ur welcome.
anyway, what is your purpose of monitoring your connection?

sure, to notify if connection lost unexpected, like internet drop, or server dead...

Have you tried ZConnection.PingServer?

HI! didi you solve the problem? I have ezxactly the same

please, tell me, its zeos dead?

anyway, what is your purpose of monitoring your connection?[/quote]