"MySql.Data.Types.MySqlConversionException" error when selecting data from a MySQL table with (4304189)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

"MySql.Data.Types.MySqlConversionException" error when selecting data from a MySQL table with
Description

Select a table that has a "timestamp" column (in Mysql)
Select the "Data" tab to view the data grid results in the following error. Error also occurs if query is run in editor:

**********************************************************************
Exception Information
**********************************************************************
Exception: MySql.Data.Types.MySqlConversionException
Message : Unable to convert MySQL date/time value to System.DateTime
Stack Trace:
   at MySql.Data.Types.MySqlDateTime.GetDateTime()
   at MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i)
   at Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
   at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
Resolution

WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for Data Analysts
Defect ID

ST80558

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title