Remote MySql-Server, timeout problem when no action for more than 60 secs

[pebogufi]

I get the message 'Lost connection to MySql server during query, Socket error on write, WSAGetLastError return 10053($2745)'

As workaround I installed a timer, making a select call in TUniQuery every 50 secs.
Any recommandation for better solution ?
Any settings on TUniConnection so be made ?
(I can't acces CrLab-help, see other thread)

[eduardosic]

I get the message 'Lost connection to MySql server during query, Socket error on write, WSAGetLastError return 10053($2745)'

As workaround I installed a timer, making a select call in TUniQuery every 50 secs.
Any recommandation for better solution ?
Any settings on TUniConnection so be made ?
(I can't acces CrLab-help, see other thread)

In TUniConnection.Options set LocalFailOver = True

in event OnConnectionLost put the code

Code: Select all

   RetryMode := rmReconnectExecute;

add unit MemData in the uses

when possible see Unidac Help About LocalFailOver and DisconnectedModel.

problem solved.

thank's CoreLab for LocalFailOver and DisconnectedModel

[pebogufi]

thanks a lot, it works.
As soon as my help will work(I don't know how) I will look at it