Good day, again.
I’m writing to report the following error in TDA v2.7 when querying a MySQL 5.1 Database (direct connection) with a DATETIME field having the value: 0000-00-00 00:00:00
I got this error:
MySql.Data.Types.MySqlConversionException
Unable to convert MySQL date/time value to System.DateTime
Stack Trace:
en MySql.Data.Types.MySqlDateTime.GetDateTime()
en MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i)
en Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
en Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
If I run the query without this field, it works OK! But, when I use SELECT * or SELECT DATE_CHECK_OUT (the field having 0000-00-00 00:00:00) I get the error showed above.
Maybe it is a TDA v2.7 bug. Could you guys please take a look at this?
Thanks in advance.
Oscar.