Unable to use with Excel for Mac

[jwhitaker-gridcog]

Hey guys,

I'm unable to use the provided release with Excel for Mac.

My understanding is that Excel for Mac requires iODBC-linked drivers, however your release only includes a binary for unixODBC. If this is right, are you able to provide binaries for iODBC MacOS as well please, and test they can be loaded out of the box from inside MS Excel?

Beyond the compilation issues, I think usage of this is also blocked by Apple's App Sandbox, which prevents Excel from loading dylibs from /usr/local or /opt/homebrew - I started down the path of trying to hack the linked dylib paths of libclickhouseodbc.dylib of libPoco etc, but this then cause code signing to throw and... bleh, this is ridiculous.

I'm trying to get our product manager going with Clickhouse, she doesn't even have brew installed much less the expertise to compile this from source or inspect dylib search paths with otool.

Thanks!

[slabko]

Hi @jwhitaker-gridcog,

Sorry to hear about all the issues running the ODBC driver on macOS. Unfortunately, use of the driver on macOS is very limited at the moment and is intended only for users who need it for development purposes.

However, I’m a bit confused, because until now I believed there were almost no applications left that support ODBC on Mac. I have MS Office installed, but I couldn’t find an option to load data from an arbitrary ODBC driver. Do I have the wrong version of MS Office, or am I missing something completely?

Here’s what I see with my version of MS Office:

[jwhitaker-gridcog]

you're in the right place :) if you pick 'from database' then the iodbc driver picker will come up, if you have it installed.

[bim-ba]

hello!
i have the same issue, maybe we have some workarounds here?