topic CLI error from SAS to Vertica in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/CLI-error-from-SAS-to-Vertica/m-p/608440#M35200 <P>Hi ,</P><P>&nbsp;</P><P>I&nbsp; am running sas code in sas EG and got the below error . The database is Vertica .&nbsp;</P><P>&nbsp;</P><P>23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; proc datasets lib=retaildw;</P><P>ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found, and no default driver</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;specified</P><P>23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; run;</P><P>&nbsp;</P><P>Please let me know why this error came .</P><P>&nbsp;</P><P>we are&nbsp; able to connect to the DB via sas if I manually assign the library (ie, without using the odbc.ini file)</P><P>&nbsp;</P><P>&nbsp;</P><P>libname mydata odbc complete="driver=/opt/vertica/lib64/libverticaodbc.so;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; database=edw;userid=jonathan.berner;pwd=MYPASSWORD;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; server=cammsaim211.corp.aimia.org"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; schema=retail_husky_public;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 30 Nov 2019 12:51:45 GMT chandu1 2019-11-30T12:51:45Z CLI error from SAS to Vertica https://communities.sas.com/t5/SAS-Enterprise-Guide/CLI-error-from-SAS-to-Vertica/m-p/608440#M35200 <P>Hi ,</P><P>&nbsp;</P><P>I&nbsp; am running sas code in sas EG and got the below error . The database is Vertica .&nbsp;</P><P>&nbsp;</P><P>23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; proc datasets lib=retaildw;</P><P>ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found, and no default driver</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;specified</P><P>23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; run;</P><P>&nbsp;</P><P>Please let me know why this error came .</P><P>&nbsp;</P><P>we are&nbsp; able to connect to the DB via sas if I manually assign the library (ie, without using the odbc.ini file)</P><P>&nbsp;</P><P>&nbsp;</P><P>libname mydata odbc complete="driver=/opt/vertica/lib64/libverticaodbc.so;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; database=edw;userid=jonathan.berner;pwd=MYPASSWORD;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; server=cammsaim211.corp.aimia.org"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; schema=retail_husky_public;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 30 Nov 2019 12:51:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/CLI-error-from-SAS-to-Vertica/m-p/608440#M35200 chandu1 2019-11-30T12:51:45Z Re: CLI error from SAS to Vertica https://communities.sas.com/t5/SAS-Enterprise-Guide/CLI-error-from-SAS-to-Vertica/m-p/608518#M35202 <P>That suggests that the connection definition in odbc.ini isn't the same as in your LIBNAME statement. Have you compared them?</P> Sun, 01 Dec 2019 00:09:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/CLI-error-from-SAS-to-Vertica/m-p/608518#M35202 SASKiwi 2019-12-01T00:09:40Z