levonk Posted September 14, 2010 Share Posted September 14, 2010 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4995 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now