We discussed this problem earlier on the old forum:

The problem is, that I already followed your hints.

1. Added MemData

2. MyConnection1.Options.LocalFailover:=TRUE;

3. RetryMode := rmReconnectExecute; (on connection lost)

As this does not work (I still get a message that the connection was lost instead of jumping to the on connection lost routine and retrying to reconnect) I tried your demo as advised.

If I disable DisconnectedMode I get also an error, when I cut the connection to my mysql server.

(integer overflow)

So maybe you can help me now? I will also send you a small sample code which connects to a mysql table.