Driver error on mac M1 Big sur 11.4

[dimaaasex91]

Hi,

I have driver error on mac M1 Big sur 11.4 Can you help me?

[traceon]

Try verifying that the driver is installed and DNS is configured correctly, using iodbctest utility (comes with libiodbc.)

[evmnaumov]

Hi! You must build the driver for x86 arch, because you use Tableau under Rosetta2.

First install Homebrew on x86 arch: arch -x86_64 /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"

Then: export PATH="/usr/local/Homebrew/bin:$PATH" - needs to use x86 arch Homebrew

Now, you can follow steps from instruction:

brew install git cmake make poco openssl icu4c libiodbc (or unixodbc if necessary instead libiodbc)

git clone --recursive https://github.com/ClickHouse/clickhouse-odbc.git

cd clickhouse-odbc && mkdir build && cd build

cmake -DCMAKE_BUILD_TYPE=RelWithDebInfo -DOPENSSL_ROOT_DIR=$(brew --prefix)/opt/openssl -DICU_ROOT=$(brew --prefix)/opt/icu4c -DBUILD_TESTING=OFF ..

-DBUILD_TESTING=OFF - works for me, while building on BigSur. Crashed without it.

cmake --build . --config RelWithDebInfo cmake --build . --config RelWithDebInfo --target package

That's all.

[Spar9a]

Hi! You must build the driver for x86 arch, because you use Tableau under Rosetta2.

First install Homebrew on x86 arch: arch -x86_64 /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"

Then: export PATH="/usr/local/Homebrew/bin:$PATH" - needs to use x86 arch Homebrew

Now, you can follow steps from instruction:

brew install git cmake make poco openssl icu4c libiodbc (or unixodbc if necessary instead libiodbc)

git clone --recursive https://github.com/ClickHouse/clickhouse-odbc.git

cd clickhouse-odbc && mkdir build && cd build

cmake -DCMAKE_BUILD_TYPE=RelWithDebInfo -DOPENSSL_ROOT_DIR=$(brew --prefix)/opt/openssl -DICU_ROOT=$(brew --prefix)/opt/icu4c -DBUILD_TESTING=OFF ..

-DBUILD_TESTING=OFF - works for me, while building on BigSur. Crashed without it.

cmake --build . --config RelWithDebInfo cmake --build . --config RelWithDebInfo --target package

That's all.

Also, for successful build you need use arch -x86_64 prefix for every next command:

arch -x86_64 brew install git cmake make poco openssl icu4c libiodbc

arch -x86_64 cmake -DCMAKE_BUILD_TYPE=RelWithDebInfo -DOPENSSL_ROOT_DIR=$(brew --prefix)/opt/openssl -DICU_ROOT=$(brew --prefix)/opt/icu4c -DBUILD_TESTING=OFF ..

arch -x86_64 cmake --build . --config RelWithDebInfo

[zmchary]

If you are using iODBC under Apple Silicon M1, just run

arch -x86_64 /usr/local/bin/brew install clickhouse-odbc

In iODBC Administrator64 which is running under Rosetta2, you can see the right version number instead of ##.## and the driver path is in /usr/local/Cellar which installed by brew under Rosetta2.

That's all.

[tarunparmar]

brew installed driver at location in Cellar but the iODBC manager does not show it , does it have to be installed by admin privilege ?

[zmchary]

brew installed driver at location in Cellar but the iODBC manager does not show it , does it have to be installed by admin privilege ?

Did you check your iODBC manager version? As showed in the picture, it should be Intel 64bit, then click Add a driver to add the driver installed by brew.