bottleboot bottleboot -3 years ago 161
PHP Question

How to add ODBC to MAMP on OSX

I'm trying to get ODBC to work on MAMP. I have tried many suggestions and solutions including those already on stackoverflow:

MAMP: Adding ODBC or SQL Server support ,
How do I add an ODBC driver to a MAMP environment?

None are successful so far.

This is the latest I tried.

I downloaded the latest ODBC connector:
http://dev.mysql.com/downloads/connector/odbc/
Installed it with the OSX DMG

I than added the driver in iODBC

I keep getting this message:


Specific driver could not be loaded


and


No suitable image found. Did find: /usr/local/lib/libmyodbc5w.so mach-o, but wrong architecture


Any suggestions?

Answer Source

Looks like you are right about the 32-bit only of iODBC.

You will need to download the Source, and compile from scratch. You will also need to download XCode through the AppStore first, so you have access to gcc and cmake.

Source Code Link: http://www.iodbc.org/downloads/iODBC/libiodbc-3.52.7.tar.gz

Note: From the CLI you can run the lipo -detailed_info /path/to/binary command. This would give you detailed information about a specified binary.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download