How to install Intersystems Caché ODBC on MacOS Mojave
Hello,
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 ?
Regards,
Kurt Hofman.
Comments
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
(1).gif)
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\ Administrator64.app
and open excel same way
DYLD_LIBRARY_PATH=/Users/daimor/Downloads/ODBC-2018.1.2.309.0-macx64/bin open /Applications/Microsoft\ Excel.app
So, you'll be able to test settings without relogin