Devart Forums

hi,

In runtime i get for one query the message : ''Lost connection during
server query''. The other 20 query components on my datamodule
don't have this problem.

The error occurs when do a search. The search code i use for this
form is the same as on other forms.

When starting the apps .exe the application will be terminated when
do the search option.

What causes this problem and how to fix it.

Regards Peter

The complete message is:

Project x raised exeption class EMYSQLException with message ''lost connection to mysql server during query''

When using ''Trace info'' in the Run menu from delphi i get the following
message :

Project x raised exeption class EMYSQLException with message
#HY000 unknown thread id: 980

mierlp wrote:The complete message is:

Project x raised exeption class EMYSQLException with message ''lost connection to mysql server during query''

When using ''Trace info'' in the Run menu from delphi i get the following
message :

Project x raised exeption class EMYSQLException with message
#HY000 unknown thread id: 980

Please, send more information:

What version of:
MySQL
MyDAC
Delphi or C++

To solve the problem try to use the Disconnected mode.
You can find more detailed information about it in the "Working in an Unstable Network" topic of MyDAC help.

mierlp wrote:The complete message is:

Project x raised exeption class EMYSQLException with message ''lost connection to mysql server during query''

When using ''Trace info'' in the Run menu from delphi i get the following
message :

Project x raised exeption class EMYSQLException with message
#HY000 unknown thread id: 980

i found the bug " unknown thread " in a specific version of mydac 4

if you are using MyDAC 4, the best choise is upgrade to MyDAC 5 and use LocalFailOver to avoid LostConnection. disconnectedModel is a great tecnology.