0
2560

Written by

Alan Howatt
Follow
Question Alan Howatt · Sep 14, 2018

setting up linux odbc to connect to cache

#Caché #ODBC

We are go to set up an odbc connection using data direct odbc on a linux redhat install, x86_64 gnu

I have downloaded the ODBC-2017.2.2.865.0-lnxrhx86.tar.gz and now need to set up the entry in the odbc

Problem is, what .so do I use??

./bin/cconnect.so
./bin/libodbc.so
./bin/libcacheodbcu.so
./bin/cgateu.so
./bin/libcacheodbciw.so
./bin/libcacheodbc35.so
./bin/libcacheodbcuw.so
./bin/libiodbc.so
./bin/libcacheodbcuw35.so
./bin/cgateiw.so
./bin/libcacheodbcu35.so
./bin/libcacheodbc.so
./bin/cgate.so
./bin/libcacheodbciw35.so
./bin/libcachedb.so
./dev/odbc/redist/unixodbc/libodbcinst.so


thanks

Discussion (3)1
Log in or sign up to continue

Comments

Ryan Hulslander · Sep 14, 2018

A good list of the various shared libraries and their descriptions can be found here  On the Docs site

So are you setting up ODBC on RedHat in order for external clients to query the Cache database, or are you setting up a data source in cacheodbc.ini so as to link tables, or use the SQL Gateway to get data from external systems?

If trying to push data and query external databases (at least to MS-SQL), I've had really good luck in building their Microsoft's MS-SQL ODBC client on Redhat and calling that. 

0
Alan Howatt  Sep 17, 2018 to Ryan Hulslander

Thanks, I found the libcacheodbc.so they referred to in the link you sent. Will give that a try.

We are connecting to cache (hopefully) on server "A" (no idea of platform at this time) from server "B" (Linux) and we are setting the odbc.ini up on server "B" to make this happen. I'll let you know. Thanks again.

0