lost connection to mysql server during query. status 10060

Avatar
Marat Khasyanov
  • updated
  • Completed
Hi! First - thanks for these greate tool! On recent update, there such %subj% error returned from mysql server 5.1, but the same query work well from linux console and from odbc connection.
How can we find the reason?

Thanks indeed,
Marat.
Replies 5
Avatar
0
Anonymous
Hello, 

This isn't something I've been able to reproduce here. Do you have this problem all the time? When exactly you get this error? After connection or during the query execution?
What version you've had before installing this one?
Avatar
0
Anonymous
Hello, 

Do you have any news about this problem?
Avatar
0
Marat Khasyanov
Hello,

Sorry for delay - was busy this week. So, as for this problem it happen al time when I execute complicated sql query with several unions, joins and subqueries, and if I simplify query using the main and huge part of query and trasfer it on mysql server view - it work fine. So, it look like query executer didn't wait enought time to get result from mysql server.
Avatar
0
Anonymous
Please try to increase the Command Timeout setting for your connection. It can be found on the Advanced tab after clicking the "More options" button in Connection Properties dialog.
Avatar
0
Marat Khasyanov
Hello,

Finally I used Command Timeout setting and it work fine now - slow query return results as expected.

Thanks.

Customer support portal powered by UserEcho