Is your Excel 32-bit? Perhaps it is looking for a 32bit driver and you have only installed
the 64bit one? Not sure how this works on a Mac.
Carl Zeiss Vision Australia (Asia Pacific)
Calculation Development & Services
J o h n B o n n e t t
Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8300
This email, including any attachments, is intended for the sole use of the intended
recipient(s) and may contain information that is confidential, privileged and/or the
sender's work. Any review or distribution by any other person is prohibited. If you are
not an intended recipient, please immediately contact the sender and delete all copies.
From: Maury Markowitz [mailto:maury.markowitz@stripped]
Sent: Monday, 18 June 2012 11:49 PM
Subject: Driver fails to load under 10.7
I am on a MacAir 10.7.4, 64-bit (I think, I should check this...)
I installed the latest MySQL 5.5.25 package for the Mac, 64-bit (I believe!) and have
successfully set up a DB 'test' and imported the northwind DB into it through the command
I have installed Connect/ODBC 5.1.11 64-bit from the DMG, and set up a DSN in ODBC
Administrator. There appears to be no setup library (is this correct?) so I guessed what
I needed to type in, setting my server to 'localhost' and the database to 'test'
In Excel I am now trying to extract data from the DSN. Using the Database panel I select
my 'MySQL' DSN and press Test. This results in a dialog about the "driver could not be
loaded" (sorry, it appears behind the excel document so I can't cut-n-paste the exact
message), and when dismissed, another appears stating that Mach-O couldn't find the right
[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 architechture
A little help?