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?
Lost connection to MySQL server during query
Re: Lost connection to MySQL server during query
Please upgrade your mydac to 3.5 and change the CommandTimeout property of TMyCommand / TMyScript.DatasetJohannes 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?