unixODBC is a mess. I installed pyodbc last week. My configuration got wonky. I couldn’t use ODBC. I couldn’t connect to Greenplum from Tableau. I was caught in the tar pit and needed help. Apple no longer supports an ODBC manager application. I decided to try one of two ODBC manager applications that I could find. I tried ODBC Manager. Here’s the About screenshot:
My verdict on ODBC Manager: Don’t use it.
I don’t think it’s a supported application. I was trying to create user DSNs. I expected the
odbcinst.ini files to get written out to directory
/Users/user/Library/ODBC. Instead, the files (at least odbcinst.ini) were written out to
The app has a bug. You can’t delete driver information from within the app. If you trash the app, the artifact of the
odbcinst.ini file will remain. To delete the file, first locate it using this command:
sudo find / -name odbc*.ini 2>/dev/null
Remove the file. Then go back into the app. The driver information is gone.
If you don’t have it installed, don’t install it. If you do have it installed, make sure to remove the ODBC configuration info and then trash the app. (I don’t think the app saves data in directories
'/Users/user/Library/Application Support', or
/Users/user/Library/Preferences/, but I can’t 100% vouch for this.) I don’t have a recommendation for a GUI for unixODBC management tasks on Mac OS X. The unixODBC project has as an aim a GUI for KDE and GNOME. Let’s hope that Apple re-releases one. In the meantime, use the command line. And, bonne chance!