AnsweredAssumed Answered

Weird ODBC error when accessing MySQL table via ESS

Question asked by cmdrsalamander on Jan 19, 2012
Latest reply on Jan 24, 2012 by jormond

Dear all,


I have an ESS/ODBC error that I cannot fix. When I try access a MySQL table via ESS, I get the following error:


ODBC Error: {MySQL][ODBC 3.51 Driver][mysqld-5.0.92-community-log]You have an erro in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers_id IN (24,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,' at line 1


I think I did the ESS config right because other tables display with no issues.

Any help would be greatly appreciated. (Translation: HELP!)