Devart Forums

I am using a registered copy of the MyDAC components for MySQL server version 5.0.x and I have run into an issue when I try to insert a record. Basically what I have written my own email antiSpam program that dumps copies of messages into a MySQL table and it works fine with smaller messages but on larger ones, I am testing with a message file that is 1.94MB in size, I get the following error "Lost connection to MySQL server query
Socket error on read. WSAGetLastError return 10054($2746)"

I have made sure that the field within the table is the right type of accept a file of this size, I have tried both MediumText and MediumBlob but I still get the same error.

Your assistance would be most appreciated.

Many thanks,

Graham

Have a look at my post http://crlab.com/forums/viewtopic.php?t=1517 , i'm sure this will solve your problem (Changing the max_allowed_packet at server to 16 mb).

That did it, thanks very much for the tip

You're welcome.. i think this two tips helped a lot of people.

GEswin, you are very much right in that statement.
Thanks.