[RESOLVED] Filling DataTable "Reading from stream failed" Please help
Hey guys, I'm having trouble filling a datatable. It was working fine before, but now Im running into some problems. The table has about 11k rows, when I try to run TableAdapter.Fill, I'm getting an error of: "Reading from the stream has failed.". This is a MySQL database
If anyone can help Id really appreciate it, really need to get this data migrated.
Heres the InnerException:
{"Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."}
Stack Trace:
" at MyNetworkStream.HandleOrRethrowException(Exception e) at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket()"
Re: Filling DataTable "Reading from stream failed" Please help
Ended up switching from the regular MySql connector (MySql.Data) to the Compact Framework (MySql.Data.CF), and that got it going for me. Guess there was a hiccup in the mySql connector