Page 1 of 1

Lost connection to MySQL server during query

Posted: Tue 15 May 2007 11:14
by Zero-G.
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

Posted: Tue 15 May 2007 11:48
by Alexey
Try to increase DataAdapter.SelectCommand.CommandTimeout property up to at least 200.

Posted: Tue 15 May 2007 13:25
by Zero-G.
Thanks! - This solved the problem!

Yours faithfully

Posted: Wed 16 May 2007 06:12
by Alexey
You are welcome.