Unable to use Vertica ODBC on Excel (Mac M1)

adezzaniadezzani Vertica Customer

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?



Best Answer

  • Bryan_HBryan_H Vertica Employee Administrator
    Answer ✓

    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.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file