Forum Discussion
OLE DB or ODBC error: DataSource.Error My SQL: Fatal Error encountered during data read
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)
3 Replies
- amitchandak
Super User
rajkurapati7 , Clear Data Source permissions once and try again
Tried that but no luck. Thank you for the reply.
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
