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
AnandVyas
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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

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