topic Re: [unixODBC][Driver Manager]Data source name not found, and no default driver specified in Administration and Deployment

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

Rajkumar20 — Tue, 31 Mar 2020 05:35:36 GMT

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.

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

AnandVyas — Tue, 31 Mar 2020 05:47:27 GMT

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!

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

KS4NCS — Thu, 29 Oct 2020 01:14:30 GMT

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.