12-12-2017 07:43 AM
Hi, We have installed sas viya 3.2 and Our database is Denodo. We need to connect to denodo to access the data using ODBC(3rd party driver). We have also installed denodo ODBC drivers on to the sas server. While we try to connect to the db, using the below script from sas studio
cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US");
libname odbclib odbc noprompt = "server = denodoIP; DRIVER = DenodoODBCDriver; userid = sas_odbc_user;
password = xxxxxxxxxx; database = dbname";
Its throwing an error as below.
12-12-2017 08:10 AM
Launch the CAS Server Monitor, http://<FQDN>:8777/cas-shared-default-http/tkcas.dsp, and go to "RunTime Environment". What are the current values for ODBCINI & LD_LIBRARY_PATH?
12-13-2017 08:19 AM
Thanks. Please add this logger to /opt/sas/viya/config/etc/cas/default/logconfig.xml:
<logger name="App.cas.tkcastkts"> <level value="trace"/> </logger>
Restart CAS server, repeat the problem and show me the most recent CAS server log.