How to install Intersystems Caché ODBC on MacOS Mojave

Question

Question

Kurt Hofman · May 13, 2019

#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

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

score 0 · Answer 1 · 2019-05-14T09:45:50-04:00

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

score 0 · Answer 2 · 2019-05-14T10:03:46-04:00

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 ?