Devart Forums

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?

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

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