Re: What are the main reasons for "Fatal error encountered attempting to read the resultset." ?
I noticed another exception which took place 4 seconds after the second exception I wrote above:
------------------------------------------------------------
[25.09.2009 23:52:30]
Computer name / User name: SERVER_2 / SERVER2
Exception type: System.IO.IOException
Action:
Loading statistics
Exception message:
Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
Inner exception type: System.Net.Sockets.SocketException
Inner exception message: An established connection was aborted by the software in your host machine
Stack trace:
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet)
at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute)
at MySql.Data.MySqlClient.NativeDriver.SetDatabase(String dbName)
at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at RA.WinForms.SuppliersOrdersStatisticsForm.ShowData(C1FlexGridEx gridToFill, MySqlCommand command, DataSet ds)
at RA.WinForms.SuppliersOrdersStatisticsForm.btnShowReadyToBeClosed_Click(Object sender, EventArgs e)
------------------------------------------------------------
Maybe it helps, because it seems these 2 exceptions are related.