When trying to connect to Denodo DB from SAS, we are facing the below issue.
CLI error trying to establish connection : [unixODBC][Driver Manager] Data source name not found, and no default driver specified.
But we have the driver 'denodoODBC' driver's installed and able to connect to other Denodo DB's configured.
Please check and suggest us.
You will have to do some configuration on SAS Foundation side in order for SAS/Access to ODBC to make a connection to the data source.
Please check the section "SAS/ACCESS Interface to ODBC" in the following link for more details:
Hi Rajkumar,If you had follow all the step as mention in the documentation and still encounter issue.Please make sure you get the latest version of unixODBC driver manager from http://www.unixodbc.org/.Hope this help.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.