MySQL connector in v7.4 breaks DATE_FORMAT() in MySQL 5.0

[mowgli]

Dates in custom RDL reports were broken and displayed as "SystemByte()" by the new MySQL connector employed in v7.4. Tested data on a Linux server where MySQL 5.1.49 was installed, and the symptom disappeared. Apparently MySql.Data.dll version 6.2.4 must have MySQL 5.1 in order for the function DATE_FORMAT() to work properly.

[drtech]

I am having issues too:
Linux server with MySQL 5.1.49...insplan errors

viewtopic.php?f=2&t=3166

[jordansparks]

surround it with CHAR() or DATE() or whatever. It's a casting issue.

[mowgli]

Yes, it can be fixed by changing all the queries individually in the reports. Would that be better than upgrading to MySQL 5.1? Would version 5.1 have any problems with Open Dental?

[jordansparks]

Sounds like an upgrade to 5.1 might be easier if not too many offices are involved. We don't have that luxury. We need to make all of our queries work with MySQL 5.0.