ODBC error

[levonk]

I am trying to connect FMP to MySQL. I got the MySQL ODBC driver, setup the DSN and added the ODBC data source to FMP. When I go to the relationship page and add my tabe I get an error saying:

ODBC Error: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''myDatabase' at line 1

I can import the data from MySQL into FMP without any problems.

The ODBC driver is v5.1.7 osx 10.6 x86.

Is this an ODBC issue or FMP issue? I have the MySQL driver v 5.1.5 running with no problems with FMP 10.

Edited September 14, 2010 by Guest