BookmarkSubscribeRSS Feed
Rajkumar20
Calcite | Level 5

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.

2 REPLIES 2
Anand_V
Ammonite | Level 13

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
Fluorite | Level 6

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

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.

Discussion stats
  • 2 replies
  • 5508 views
  • 0 likes
  • 3 in conversation