Question
· Sep 14, 2018

setting up linux odbc to connect to cache

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

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.