Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two applications in my Applications/Utilities folder that look exactly the same except for the icon. One is ODBC Manager, the other is ODBC Administrator.

Does anyone know what the difference between these two is?

share|improve this question
up vote 3 down vote accepted

ODBC Administrator was shipped with Mac OS X until 10.6 Snow Leopard, when it be came a separate download from the Apple support site.

ODBC Manager is an independently developed application that is functionally equivalent to the Apple ODBC Administrator. It is installed with the Actual ODBC Pack drivers from Actual Technologies (and potentially other 3rd party ODBC drivers).

If you are using 10.5 Leopard or earlier, or if you have installed Apple's Administrator from the support site, then you may have both administrators. You can use either one - Manager is intended to be equivalent (with some of Apple's bugs fixed).

Jonathan Monroe, Actual Technologies

share|improve this answer
That makes sense, since I bought your excellent ODBC Open Source Driver pack. Thanks for the answer! – John Gallagher Feb 12 '10 at 13:50

In hopes of minimizing potential future confusion...

Jonathan Monroe's comments are generally correct, but incomplete.

You may additionally encounter the OpenLink ODBC (/Applications/Utilities/), also and originally known as the iODBC (/Applications/iODBC/), which was the original ODBC administrator on Mac OS X, before Apple produced their own ODBC (/Applications/Utilities/).

The OpenLink ODBC is shipped as part of the iODBC SDK for Mac OS X and with all drivers from OpenLink Software (my employer), who maintains and supports the iODBC Project itself. Other driver vendors may also include this administrator and/or SDK in their installers.

All of these administrators are linked to the same iODBC libraries ("dylibs") and/or Frameworks, and all settings should wind up in the same files (/Library/ODBC/odbc.ini, /Library/ODBC/odbcinst.ini, ~/Library/ODBC/odbc.ini, ~/Library/ODBC/odbcinst.ini).

Due to some bugs in older versions of iODBC and in various third-party installers, some other configuration files (most commonly and problematically, ~/.odbc.ini and ~/.odbcinst.ini; others include /etc/odbc.ini, /etc/odbcinst.ini, /etc/.odbc.ini, /etc/.odbcinst.ini) may exist on your Mac, and these may cause some trouble with various applications (e.g., System DSNs may not save at all, or may erroneously be seen in the User DSNs tab). If you encounter such issues, the fix is to blend the content of these alternatively located files into the default files (in ~/Library/ODBC/ for user-level config, or in /Library/ODBC/ for system-level config), and replace each with a symlink to the appropriate default files (or simply remove the errant files and adjust any application configuration to target the default locations).

OpenLink's Technical Support team can assist with this cleanup, if needed. There is no cost for such assistance, if pursued through the web-based Case System.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .