Skip to main content
Question

Unable to use Vertica ODBC on Excel (Mac M1)

  • March 28, 2023
  • 4 replies
  • 11 views

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

4 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • March 28, 2023

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
  • Author
  • New Participant
  • March 29, 2023

Thanks a lot Bryan!


akpl
  • New Participant
  • May 22, 2023

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
Forum|alt.badge.img+1
  • Participating Frequently
  • May 22, 2023

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

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