unable to connect to db using ODBC

[AmitSri]

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.

ERROR: The ODBC engine cannot be found.

ERROR: Error in the LIBNAME statement.

Could anyone let us know what is causing this error. Also is there any way to check if the ODBC configuration is proper or not. Thanks!!

[alexal]

@AmitSri,

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?

[AmitSri]

Hi Alex,

I have checked it. And the values are as follows:

ODBCINI /etc/odbc.ini
ODBCINSTINI /etc/odbcinst.ini

[alexal]

@AmitSri,

What about LD_LIBRARY_PATH?

[AmitSri]

And here is the LD_LIBRARY path in the attachment. Thanks!!

[alexal]

@AmitSri,

I would like to review these files:

• /etc/odbc.ini
• /etc/odbcinst.ini

[AmitSri]

Okay. Please find them here. Thanks!!

[AmitSri]

Hi Alex,

Sorry, Have semt you the wrong files. Please find the correct files here.

Thanks,

Sri

[alexal]

@AmitSri,

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.

[AmitSri]

Thanks Alex!!

I have added the logger to the xml. Now, to restart the cas server, Should I setup the cascontroller to run as a service?

[alexal]

@AmitSri,

Just use this command:

sudo systemctl restart sas-viya-cascontroller-default

[AmitSri]

Okay.. its alraedy a service available at /etc/init.d. So I had restarted it. Will send the log in a while. Thanks!!

[AmitSri]

Hi Alex,

Please find the log here. Kindly have a look at it and suggest us. Thanks!!