Dear newsgroup,

I'm having a critical problem with the MySQL Connector .NET 1.0.6. I'm
developing a .NET (Version 1.1 SP1) application on a Windows 2000
Professional machine with MySQL Server 4.1.14.

A huge SQL query does run for about 40 minutes but then aborts with the
exception "Connection unexpectedly terminated". If I comment out some time
and memory consuming calculations the query does run a bit further but then
also terminates. It seems like there is a relation between the memory used
by my application (which constantly grows while it's running) and this
problem. I am using a MySqlReader to fetch the results row by row. I found
out that if I am using a "classical" MySqlQuery, apply a LIMIT on the SQL
and call it several times (with different LIMITs of course), the problem
does not occur BUT this is certainly not as high-performance as using a
MySqlReader.

The bug is registered in the MySQL bug tracking system
(http://bugs.mysql.com/bug.php?id=6688) since 17th November of last year
(!) and there has been no fix.

I also tried MySQL Server 4.1.15 and 5.0.15 -> same problem.

I wonder if anyone came across this problem and found a resolution?

--
Sincerely
Sven Jacobs