Learn how to a build a cloud-first strategyRegister Now


Error with MySQL ODBC connector on Mac OS X

Posted on 2011-05-03
Medium Priority
Last Modified: 2012-05-11
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/libmyodbc5.so, 6): no suitable image found.  Did find:
/usr/local/lib/libmyodbc5.so: 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! :)
Question by:freestate
LVL 25

Accepted Solution

Will Loving earned 2000 total points
ID: 35512493
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.

Author Comment

ID: 35688325
That's done the trick - thanks!

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question