Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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 Administrator.app (/Applications/Utilities/) or iODBC Administrator.app (/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
add comment

Your Answer

 
discard

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.