Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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'm trying to connect Excel in OS X to a Vertica database and I have their ODBC driver working with iodbctest but when I boot Excel and click on Database I get "No ODBC driver installed"

What are the next debugging steps?

share|improve this question

You probably just need to install the full iODBC SDK, which includes the iODBC Frameworks against which Microsoft Excel and its helper Microsoft Query were built. (iODBC is a freely licensed, open source project.)

For best results, use the OpenLink ODBC (/Applications/Utilities/) or iODBC (/Applications/iODBC/) to configure your DSN(s).

If you have manually configured things to this point, note that for use with Excel, System DSNs should be stored in /Library/ODBC/odbc.ini, and User DSNs should be in ~/Library/ODBC/odbc.ini; drivers should be registered in /Library/ODBC/odbcinst.ini.

share|improve this answer
Thanks TallTed, I had a similar issue but connecting to a postgresql database from Excel. Installing the iODB SDK helped me to resolve it. – BenM Aug 14 '12 at 23:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.