Lost connection to MySQL server during query

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Johannes Lombaard

Lost connection to MySQL server during query

Post by 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?

Serious

Post by Serious » Fri 04 Feb 2005 13:23

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

Guest

Re: Lost connection to MySQL server during query

Post by 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

Post Reply