The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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