I'm trying to use psqlODBC on OS X 10.6. I compiled from source with configure arguments
--with-iodbc --with-libpq=/opt/local/lib/postgresql90
I installed PG9 via MacPorts.
Using the iODBC driver test script gives me the errors:
1: SQLDriverConnect = [iODBC][Driver Manager]dlopen(/usr/local/lib/psqlodbcw.so, 6): no suitable image found. Did find:
/usr/local/lib/psqlodbcw.so: mach-o, but wrong architecture (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003
The Makefile appears to have correctly determined my architecture (x86_64-apple-darwin10.8.0).
Any sugestions? Is there a better way to get the ODBC driver for OS X? It didn't appear to be included with any of the various packages in MacPorts.
-B