How to install Intersystems Caché ODBC on MacOS Mojave


I'm trying to get ODBC running on a Mac but I don't get it working.

Has someone an overview how te install,configure and use it in Excel on MacOSX ?


Kurt Hofman.

  • 0
  • 0
  • 76
  • 2
  • 1


What do you have already?

Did you configure ODBC DSN, DYLD_LIBRARY_PATH?

Some information about configuring ODBC, you can find here.

First of all I think you need iODBC installed on your mac.

then ODBC Caché drivers, with correct environment variable DYLD_LIBRARY_PATH, do not forget to relogin after the set variable.

As proof, that's possible to do it. Done with Caché 2018.1


Thanks, but I can(t find the correct way to install Caché ODBC.  Do I have to extract it in a special folder or so and then follow the UNIX-like installation or something else ?

It actually, does not matter, where to install drivers.

My Caché works in docker, so, I downloaded ODBC drivers from the ftp.

extracted it, just in Downloads, and run there ODBCInstall from a terminal.

with ODBCInstall I got file mgr/cacheodbc.ini, which I copied to ~/Library/ODBC/odbc.ini, there will be as User DSN. /Library/ODBC/odbc.ini for System DSN.

DYLD_LIBRARY_PATH should follow to bin folder in extracted ODBC Drivers folder

in my case 

export DYLD_LIBRARY_PATH=/Users/daimor/Downloads/ODBC-2018.1.2.309.0-macx64/bin

you can check connection with iODBC Manager, running right from terminal

DYLD_LIBRARY_PATH=/Users/daimor/Downloads/ODBC-2018.1.2.309.0-macx64/bin open /Applications/iODBC/iODBC\

and open excel same way

DYLD_LIBRARY_PATH=/Users/daimor/Downloads/ODBC-2018.1.2.309.0-macx64/bin open /Applications/Microsoft\

So, you'll be able to test settings without relogin