Lost connection to MySQL server during query

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Zero-G.
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Lost connection to MySQL server during query

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
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 15 May 2007 11:48

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

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

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

Thanks! - This solved the problem!

Yours faithfully

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 16 May 2007 06:12

You are welcome.

Post Reply