[unixODBC][Driver Manager]Data source name not found, and no default driver specified

[Rajkumar20]

Hi Team,

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.

Regards,

Rajkumar Sadagopan.

[Anand_V]

Hi @Rajkumar20 

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:

https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

Thanks!

[KS4NCS]

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.