Why this error appear WSAGetLastError return 10054($2746)

Daniel Fagnan · Post by **Daniel Fagnan** » Thu 29 Nov 2007 23:58

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

Antaeus · Post by **Antaeus** » Fri 30 Nov 2007 10:10

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.

Daniel Fagnan · Post by **Daniel Fagnan** » Tue 04 Dec 2007 23:21

All fetch all = True
We received yet this message.
They are another thing to checked.

Antaeus · Post by **Antaeus** » Wed 05 Dec 2007 14:06

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.

Daniel Fagnan · Post by **Daniel Fagnan** » Wed 05 Dec 2007 22:28

CodeGear™ RAD Studio 2007 Version 11.0.2804.9245
MyDac 5.20.0.12
MySQL server version: 5.0.45

Antaeus · Post by **Antaeus** » Thu 06 Dec 2007 08:30

We did not receive your test sample. If you already sent it, please try to resend it once again.

Devart Forums

Why this error appear WSAGetLastError return 10054($2746)

Why this error appear WSAGetLastError return 10054($2746)

We checked all Fetch

All fetch all = True