I'm bootstrapping myself through the entire ODBC stack it seems, but I do feel I am making some progress - I hope. I now have copies of MySQL, Firebird and SQLite db's and ODBC drivers on my machine and I'm trying to get all the way through to the final stage of a successful connection. Now I'm running into a new error...
Setup: MacAir, 10.7.4, latest iODBC (I guess, comes installed, right?), latest ODBC Manager. DBs installed and can be accessed from the command line tools for each of the systems.
For easy testing, I'm using Excel's MS Query UI. Selecting any of my DSN's in MS Query and pressing the Test button results in this error dialog:
[iODBC][Driver Manager]Specified driver could not be loaded
then when that is dismissed another appears:
[iODBC][Driver Manager]dlopen(/usr/local/lib/libmyodbc5.so, 6): no suitable image found. Did find: /usr/local/lib/lobmyodbc5.so: mach-o, but wrong architecture
Ok, so perhaps MS Query is 32 and the driver is 64, or vice versa. I don't *really* know how to check the MS stuff, but I do know how to check the libs:
Maurys-MacBook-Air-2:lib maury$ lipo -info libmyodbc5.so
Non-fat file: libmyodbc5.so is architecture: x86_64
Ok, so maybe Query is 32 and Connect/ODBC is 64? Let's lipo another driver...
Maurys-MacBook-Air-2:lib maury$ lipo -info libfbclient.dylib
Architectures in the fat file: libfbclient.dylib are: i386 x86_64
Ok, this one should work, right? Nope, same error... ok, one last try...
Maurys-MacBook-Air-2:lib maury$ lipo -i /usr/lib/libsqlite3odbc-0.83.dylib
Non-fat file: /usr/lib/libsqlite3odbc-0.83.dylib is architecture: i386
Ok this is pure 32-bit, let's see...
Oh, OK, that's different, but still no luck.
If anyone has a tool that's pure 32 and/or 64 bit that goes through the iODBC driver stack, I'd like to give it a try. In the meantime, am I even reading the error message correct? It doesn't *really* say.