Devart Forums

I using myDAC 4.30 in Delphi 7 application, the server running Windows Xp Professional, the station running Windows 98.

the exceptions is raised:

1 - Lost Connection to MySQL server during query
Socket error on read, WSAGetLastErros return 10053($2745)

2 - #HY000'ID' From 'Thread' 223 Unknwon.

3 - Lost Connection to MySQL server during query.

in myDAC 4.00.2.8, the exceptions never is raised.

set TmyConnection.Direc := False is a temporary Solution?

All the TmyQuery.FetchAll = False.

You should post more details when this exceptions happens. If it happens when opening a query, connecting, etc.. Also remember that if you work with threads you should use a connection for each thread.

GEswin wrote:You should post more details when this exceptions happens. If it happens when opening a query, connecting, etc.. Also remember that if you work with threads you should use a connection for each thread.

this exception occurs when call method Dataset.close;

As I must use a connection for each thread, in the previous versions of myDAC this never happened.

There is a few workarround :

set Fetchall = True

or

set fetchall = False and BEFORE closing the table do Table.last

or

update to latest Mysql 5.x

This is MyDAC bug. Please see our answer in http://crlab.com/forums/viewtopic.php?p=9442 thread.

Antaeus wrote:This is MyDAC bug. Please see our answer in http://crlab.com/forums/viewtopic.php?p=9442 thread.

I know, I initiated that one thread, and for exceptions:

1 - Lost Connection to MySQL server during query
Socket error on read, WSAGetLastErros return 10053($2745)

3 - Lost Connection to MySQL server during query.


i upgrade mySQL to last version but this exception occurs.

when new release of myDAC is available?

thanks.

New build of MyDAC will be available during nearest two weeks.