Error with MySQL ODBC connector on Mac OS X

I have downloaded and installed what seems to be the appropriate MySQL driver for ODBC connections on a Mac, but get the following error when I try and use the connection through FileMaker pro:

ODBC Error: [iODBC][Driver Manager]dlopen(/usr/local/lib/, 6): no suitable image found.  Did find:
/usr/local/lib/ mach-o, but wrong architecture
[iODBC][Driver Manager]Specified driver could not be loaded

There doesn't seem to be any information on this error on Google (one unanswered post on the MySQL lists) - can anybody provide a solution?

Time is of the essence, as I need to get this working for a client and had a baby due yesterday! :)
Who is Participating?
Will LovingConnect With a Mentor PresidentCommented:
Nothing like a little time pressure to help you get things done, eh?

I'm not familiar with the exact error you are getting, but for Mac to SQL connections I use/recommend the driver from Actual Technologies:

You can download and install the driver which installs an applications called "ODBC Manager" in your Utilities folder. The demo version is fully functional except that it will only show you the first three records of the external mySQL table that you connect to, so you can test it fully before paying the relatively modest fee.

You need to do two steps to access and ODBC source within FileMaker. 1) Open the ODBC Manager application and configure a DSN (Data Source Name) for the MySQL database, and 2) In FileMaker's External Data Sources setup screen: File -> Manage -> External Data Sources - create a new ODBC data source and select the DSN that you created.

Try using the Actual driver and see if you have better luck. Note that when you setup the DSN in the ODBC Manager it gives you the option to test the connection right there so you can be sure that it works before you ever get to step 2. The ODBC Manager utility is almost identical in appearance to the similar built-in utility in Windows.
freestateAuthor Commented:
That's done the trick - thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.