Start a conversation

TracerPlus Connect Boolean to Bit conversion issues when using MySql ODBC driver version 5.2.4

In some regions when using the MySql ODBC driver version 5.2.4, conversion of the TracerPlus True/False checkbox values will fail when syncing to a MySql Bit(1) field. This issue does not occur on MySql ODBC drivers of 5.1.12 and below.

The exact message that will appear in the TracerPlus Connect event log is as follows:

    **Exception received: Input string was not in a correct format.Couldn't store <False> in <bit(1)field> Column. Expected type is Int16.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Howard Heckman III

  2. Posted
  3. Updated

Comments