Lost connection to MySQL server during query

pleitch · Post by **pleitch** » Fri 29 Sep 2006 05:49

using MyDAC 4.40.0.18 for Delphi 5

My app worked fine with MyDAC 4.00.1.6 but loses the connection on some querys after the upgrade. I have tried changing the settings as per FAQ but no luck.

I use a TMyQuery / TDataSetProvider / TClientDataSet

The SQL is: "select * from test_table". It is a small table and I want to insert a small number of rows. It is fine for a couple of rows but later bombs with the above error.

If I use just the TMyQuery with CachedUpdates, all is fine. When combined with TDataSetProvider / TClientDataSet it bombs when I call ApplyUpdates and before it reaches the BeforeUpdateRecord procedure.

thxs

Antaeus · Post by **Antaeus** » Fri 29 Sep 2006 12:11

We could not reproduce the problem. Please try to determine any dependences. Does the problem appear depending on some row types (e.g. BLOB fields) or it appears depending on inserted values or something else. Also check if any settings of the MySQL Server were changed. If you are unable to find the reason of the problem then send us (evgeniyD*crlab*com) a complete small sample to demonstrate the problem, including script to create and fill test table. Also supply us with exact version of MySQL server. You can see it in Info sheet of TMyConnection Editor.

Antaeus · Post by **Antaeus** » Mon 02 Oct 2006 15:24

Thank you for sample. It did help us very much. We have fixed this problem. This fix will be included in the next MyDAC build.

snorkel · Post by **snorkel** » Tue 24 Oct 2006 20:20

Antaeus wrote:Thank you for sample. It did help us very much. We have fixed this problem. This fix will be included in the next MyDAC build.

is this fix in 4.30.1.19? I get the same problem sometimes.

thanks,

Snorkel

khh · Post by **khh** » Wed 25 Oct 2006 01:55

Same with me!

Started when I used FetchAll = False

I set it back to True but the message still coming when I close my programme.

Antaeus · Post by **Antaeus** » Wed 25 Oct 2006 13:03

No, this fix was not applied to MyDAC 4.40.0.19 it will be applied to the next MyDAC build.