WSAGetLastError return 10054($2746)

Graham9295 · Post by **Graham9295** » Wed 15 Mar 2006 12:00

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

GEswin · Post by **GEswin** » Wed 15 Mar 2006 21:46

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).

Graham9295 · Post by **Graham9295** » Thu 16 Mar 2006 20:18

That did it, thanks very much for the tip

GEswin · Post by **GEswin** » Thu 16 Mar 2006 22:23

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

arno · Post by **arno** » Mon 19 Jun 2006 09:11

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