SAS Viya: Connect to DB using ODBC - OS = Linux Redhat 7.4

[daithi1990]

Hi, 

I'm currently trying to setup a connection via CAS to a source database

I've setup the connection on the Linux server via unixODBC and it connects successfully. 

However when I try to access this via SAS it throws the following error below. I've updated the cas.settings file and restarted CAS service to update the ODBCINI, ODBCINSTINI & LD_LIBRARY_PATH Variables as required. These are reflected in the CAS Browser Console (tkcas.dsp). I'm struggling to figure out why the connection to the driver failed. 

ERROR: The connection to the data source driver failed.

ERROR: General Error - invalid Exception

ERROR: Function failed.

ERROR: The action stopped due to errors.

Any hints tips or pointers would be appreciated. 

Thanks, 

David 

[daithi1990 · Accepted solution]

There was an encoding issue with the openODBC drivers and as such the encoding had to be added into the CASLIB statement. 

 caslib odbccaslib datasource=(srctype="odbc" odbc_dsn="MySQL" dm_unicode="utf-16" );