OLE DB or ODBC error: DataSource.Error My SQL: Fatal Error encountered during data read

[rajkurapati7]

I am not able to import the data from MYSQL database. when I try to load the table, I am getting the following error:

OLE DB or ODBC error: DataSource.Error My SQL: Fatal Error encountered during data read

Exception:
ExceptionType: Microsoft.Mashup.Evaluator.Interface.MessageChannelException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
Message: Error reading from or writing to stream.
StackTrace:
at Microsoft.Mashup.Evaluator.StreamMessenger.Read()
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.Interface.IMessengerExtensions.WaitFor[T](IMessenger messenger, Action`2 handler)
at Microsoft.Mashup.Evaluator.Interface.IMessengerExtensions.WaitFor[T](IMessenger messenger)
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)

[rajkurapati7]

Here is the solution:

Currently, we can get rough this by creating dataflow from the service and creating a dataset on the the same dataflow. That way we can download all the data without any error.

Mark my post as a solution! Appreciate it

[rajkurapati7]

Tried that but no luck. Thank you for the reply.

[amitchandak]

@rajkurapati7 , Clear Data Source permissions once and try again