Lost connection to MySQL server during query

Zero-G. · Post by **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

Alexey · Post by **Alexey** » Tue 15 May 2007 11:48

Try to increase DataAdapter.SelectCommand.CommandTimeout property up to at least 200.

Zero-G. · Post by **Zero-G.** » Tue 15 May 2007 13:25

Thanks! - This solved the problem!

Yours faithfully

Alexey · Post by **Alexey** » Wed 16 May 2007 06:12

You are welcome.