Lost connection to MySQL server during query

Lost connection to MySQL server during query

Postby Johannes Lombaard » Fri 04 Feb 2005 12:27

I'm using Delphi 6, with Mydac 3.30. MySql is installed on Win 2000 Server Sp5. Table type id InnoDB.

Whenever you open the database and tables from the server, everything works 100%, but whenever any client (Winxp, Win98) login and while the tables are opened, most of the times I get "Lost connection to MySQL server during query"

I can't say that it is one specific table causing it, because it changes.

Can anyone point me in a direction as I don't know anymore?
Johannes Lombaard
 

Postby Serious » Fri 04 Feb 2005 13:23

Look for reply to this post in MySQL Data Access Components forum.
Serious
 

Re: Lost connection to MySQL server during query

Postby Guest » Tue 08 Feb 2005 02:40

Johannes Lombaard wrote:I'm using Delphi 6, with Mydac 3.30. MySql is installed on Win 2000 Server Sp5. Table type id InnoDB.

Whenever you open the database and tables from the server, everything works 100%, but whenever any client (Winxp, Win98) login and while the tables are opened, most of the times I get "Lost connection to MySQL server during query"

I can't say that it is one specific table causing it, because it changes.

Can anyone point me in a direction as I don't know anymore?


Please upgrade your mydac to 3.5 and change the CommandTimeout property of TMyCommand / TMyScript.Dataset
Guest
 


Return to MySQL Data Access Components