Socket 10054 Error

[mydac4std]

I get the following error "Lost connection to MySQL server query
Socket error on read. WSAGetLastError return 10054($2746)"

Client Side:
MyConnection1
property
Connection Timeout : 300
CharSet : euckr
Compress: false
Direct : true
Embedded:false
keepDesignConnected:true
MyQuery
CommandTimeout : 0
FetchAll : false


Server Side: Renux

[eduardosic]

I get the following error "Lost connection to MySQL server query
Socket error on read. WSAGetLastError return 10054($2746)"

Client Side:
MyConnection1
property
Connection Timeout : 300
CharSet : euckr
Compress: false
Direct : true
Embedded:false
keepDesignConnected:true
MyQuery
CommandTimeout : 0
FetchAll : false


Server Side: Renux

check file my.ini on mySQL server...

try the variables:

connect_timeout = 99999999
interactive_timeout = 99999999
net_read_timeout = 99999999
net_write_timeout = 99999999
slave_net_timeout = 99999999
wait_timeout = 99999999
max_connections = 99999999
max_user_connections = 99999999

I had this problem, later that I changed the variable, I was ok.

[Antaeus]

The problem can appear if you work with BLOB fields and try to load a file with size greater than value of max_allowed_packet server variable. To solve this problem you should increase value of max_allowed_packet variable. For more information read MySQL Reference Manual.

[GEswin]

Antaeus is right. Also specify when you get exactly this problem (sql sentence, operation...) to get more specific help.