Lost connection to MySQL server during query

Lost connection to MySQL server during query

Postby Zero-G. » Tue 15 May 2007 11:14

Hey

I use the latest building of your Professional product.

I have a SQL Statement which is using a long time (in a third party programm for mysql it tells me, that the query needs up to 180 seconds to be done)
when I fill a DataAdapter, I get the error written in the Subject.

I tried to set the ConnectionTimeout to 0 but this dosen't help

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby Alexey » Tue 15 May 2007 11:48

Try to increase DataAdapter.SelectCommand.CommandTimeout property up to at least 200.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Zero-G. » Tue 15 May 2007 13:25

Thanks! - This solved the problem!

Yours faithfully
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby Alexey » Wed 16 May 2007 06:12

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL