Unable to use Vertica ODBC on Excel (Mac M1)

adezzani

Hi all,

I'm trying to connect Vertica ODBC on Excel and I'm using a Mac M1 (but the ODBC is working fine in PyCharm).
I already installed an iODBC manager (I tried with different ones) but, when I'm selecting the Vertica ODBC, I get these errors:

First error: [iODBC][Driver Manager]Specified driver could not be loaded

Second error: [iODBC][Driver Manager]dlopen(/Library/Vertica/ODBC/lib/libverticaodbc.dylib, 0x0006): tried: '/Library/Vertica/ODBC/lib/libverticaodbc.dylib' (fat file, but missing compatible architecture (have 'x86_64', need 'arm64')), '/System/Volumes/Preboot/Cryptexe

Did someone experience the same issue?

Thanks,
Alessandro

Bryan_H

ARM architecture support will be available with version 12.0.4 ODBC driver, due out very soon. I will update this thread when it's released, or open a support case for direct notice when it's available.

adezzani

Thanks a lot Bryan!

akpl

Is it available at 12.0.4? I don't see corresponding .so for Linux neither can I install .pkg to M1-based Mac

SruthiA

@akpl : ODBC driver for Mac is available on the downloads page.

https://www.vertica.com/download/vertica/client-drivers/