Page 1 of 1
Socket 10054 Error
Posted: Wed 07 Jun 2006 01:20
by 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
Re: Socket 10054 Error
Posted: Wed 07 Jun 2006 01:49
by eduardosic
mydac4std wrote: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.
Posted: Wed 07 Jun 2006 15:29
by 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.
Posted: Wed 07 Jun 2006 22:10
by GEswin
Antaeus is right. Also specify when you get exactly this problem (sql sentence, operation...) to get more specific help.