New post
Question
· May 13, 2019

How to install Intersystems Caché ODBC on MacOS Mojave

#ODBC #Caché

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.

Discussion (3)1
Log in or sign up to continue
Dmitry Maslennikov · May 14, 2019

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

0 0
Dmitry Maslennikov May 14, 2019 to Kurt Hofman

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

0 0