Page 1 of 1

WSAGetLastError return 10054($2746)

Posted: Wed 11 Nov 2009 14:29
by 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

Posted: Thu 12 Nov 2009 11:06
by 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.