MyDACDemo broken due to inconsistent tablename case

[gwideman]

Folks:
Most of the demos in MyDACDemo result in table-not-found errors, because the names used in the demo queries are different from the names used in the Create script -- they use different combinations of upper and lower case. Eg: EMP vs Emp.

This is OK on Windows, but not on linux, because the MySQL tables are stored in files (named according to tablename), and on linux upper/lower case of the filenames is significant.

Is there anything simple that can be done about this? Or must the user try to find all the places that a tablename appears, and fix the case?

Graham

[Dimon]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.
As a temporary solution you can set the lower_case_table_names variable to 1 for your MySQL server.