WSAGetLastError return 10054($2746)

[pedja2]

Hello there,

I am using mydac 5.90.0.52 in our application and some of our customers getting a few times per day error:

Lost connection to MySQL server during query. Socket error on write.
WSAGetLastError return 10054($2746)

Mysql version is 4.1.11
Variable net_write_timeout =300 , 5 minutes must be enough

What this means and could bu suppressed of solved?

Thanks.
Pedja

[Dimon]

This problem can be arised when connection break occurs, for example in an unstable network.
To solve the problem try to set the TMyConnection.Options.LocalFailover property to True. You can find more detailed information about this in the "Working in an unstable network" topic of MyDAC Help.