Unable to finish service due to mysql date in db

question_mark_1.png

Question

What to do in case of error Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. See https://mysqlconnector.net/connection-options/ ?

Answer

If this error occurs, it should be enough to put at the end of the connection string ConvertZeroDateTime=True;.

Revision #2
Created 15 March 2022 08:07:44
Updated 31 July 2026 16:23:39 by Jitka Kalíšová