> Thanks, have you used the one in the "enterprise db" installer > at all or > only the MacPorts one? > Can you confirm if it works with iodbctestw? Do you use an > "ODBC > adminstrator" e.g. "Openlink ODBC Administrator" or only > config files? > Only MacPorts, through unixODBC. I have not had much luck in the past > with the Openlink stuff, or iODBC, which is why we moved to MacPorts. > FWIW I had the same problems with the MySQL ODBC drivers. Thanks, good to know that the unixODBC part at least works.. However unfortunately the application in question only currently use iODBC.
That's interesting.... the last time I tried to compile the myODBC drivers from source on OS X I failed completely. I couldn't seem to find out how the folks at Oracle do it.
What you say about myODBC was true up until about a year ago (or maybe even more recently my memory is failing me) but the latest myODBC drivers actually work pretty well and do so with iodbc so its definitely possible to have working iodbc drivers on osx.
I realized as this thread was developing that while technically I am running psqlODBC on OS X, MacPorts is really a completely different animal. I guess that is the central curse of MacPorts --- it generally all works well together, but you need to use the whole kit and kaboodle.
The one success I have had with iODBC and OS X was with HP Vertica. It took a lot of scouring of the documentation provided by HP, but in the end I do finally have them working, at lease from Python.