Error with MySQL ODBC connector on Mac OS X

Posted on 2011-05-03
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/, 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! :)
Question by:freestate
    LVL 24

    Accepted Solution

    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

    That's done the trick - thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now