See Oracle ODBC & JDBC-ODBC connection
use unixODBC-2.2.11-19.x86_64.rpm on Suse Linux2.6.16.53-0.16-smp #1 x86_64 x86_64 x86_64 GNU/Linux odbcinst -j ----- unixODBC 2.2.11 DRIVERS............: /etc/unixODBC/odbcinst.ini SYSTEM DATA SOURCES: /etc/unixODBC/odbc.ini USER DATA SOURCES..: /home/lmg/.odbc.ini #carefull! this override the initial places unixODBC looks for your data sources. export ODBCINI=/home/martin/mydsns.ini export LD_LIBRARY_PATH=/usr/lib64 export PATH=$PATH:$LD_LIBRARY_PATH #test isql LMG05 sys pwd |
WX2 settings #[odbcinst.ini] [ODBC] Trace = No TraceFile = /tmp/unixODBC.log [WX2] Driver = /opt/kognitio/wx2/current/lib/Linux64/libwcsodbc.so #[LMG05] Description = Kognitio WX2 ODBC Driver = WX2 ServerAddress1 = 10.3.13.10 ServerPort1 = 6550 ServerAddress2 = ServerPort2 = ServerAddress3 = ServerPort3 = ForceConnect = N Timeout = 3 PrivateKey = SslEnabled = Y SslAllowFallback = Y WX2PreserveCursors = N WX2AutoCommit = Y WX2KeepAlive = Y WX2Directory = . WX2Locale = 4 WX2ODBCDbg = N WX2ODBCDbgFile = /tmp/wx2odbc.log |