Devart Forums

Posted: **Sun 15 Jun 2008 11:06**

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)

Posted: **Mon 16 Jun 2008 01:51**

pebogufi wrote: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

Posted: **Mon 16 Jun 2008 15:48**

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

Devart Forums

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

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

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