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?
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 (
If you have manually configured things to this point, note that for use with Excel, System DSNs should be stored in