Get TracerPlus on Google Play and scan barcodes with your android devices. Download a free trial of TracerPlus and create your own mobile barcode and RFID applications
Knowledgebase: TracerPlus Connect
TracerPlus Connect Boolean to Bit conversion issues when using MySql ODBC driver version 5.2.4
Posted by Howard Heckman III on 16 April 2013 05:11 PM

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.

(2 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).