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

daithi1990 — Fri, 02 Feb 2018 02:01:28 GMT

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

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

daithi1990 — Fri, 16 Feb 2018 05:51:33 GMT

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" );

topic Re: SAS Viya: Connect to DB using ODBC - OS = Linux Redhat 7.4 in Administration and Deployment

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

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