Page 1 of 1
Why this error appear WSAGetLastError return 10054($2746)
Posted: Thu 29 Nov 2007 23:58
by Daniel Fagnan
When I open a query I catch all error I received this error very often
but all seem to be ok .
My log file we received this message
Why
2007-11-29 09:08 09:08:39 : Lost connection to MySQL server during query
Socket error on write. WSAGetLastError return 10054($2746)
Daniel Fagnan
Posted: Fri 30 Nov 2007 10:10
by Antaeus
It is likely that you are working in FetchAll=False mode. In FetchAll=False mode data is fetched asynchronously. If you close an uderfetched dataset in this mode, MyDAC forces the additional connection to close by executing the KILL command. The additional connection is created to avoid blocking of the main connection when fetching data asynchronously.
We checked all Fetch
Posted: Tue 04 Dec 2007 23:21
by Daniel Fagnan
All fetch all = True
We received yet this message.
They are another thing to checked.
Posted: Wed 05 Dec 2007 14:06
by Antaeus
There are many possible causes of this problem. We need more information to determine its reason and find a solution. Please, prepare a complete small sample and send it to us at sdac*crlab*com.
Also supply the following information:
- exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- exact version of your IDE;
- exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.
All fetch all = True
Posted: Wed 05 Dec 2007 22:28
by Daniel Fagnan
CodeGear™ RAD Studio 2007 Version 11.0.2804.9245
MyDac 5.20.0.12
MySQL server version: 5.0.45
Posted: Thu 06 Dec 2007 08:30
by Antaeus
We did not receive your test sample. If you already sent it, please try to resend it once again.