[RESOLVED] Filling DataTable "Reading from stream failed" Please help

[cellus205]

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()"

[cellus205]

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