CLI error from SAS to Vertica

[chandu1]

Hi ,

I  am running sas code in sas EG and got the below error . The database is Vertica . 

23         proc datasets lib=retaildw;

ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found, and no default driver

       specified

23       !                             run;

Please let me know why this error came .

we are  able to connect to the DB via sas if I manually assign the library (ie, without using the odbc.ini file)

libname mydata odbc complete="driver=/opt/vertica/lib64/libverticaodbc.so;

                              database=edw;userid=jonathan.berner;pwd=MYPASSWORD;

                              server=cammsaim211.corp.aimia.org"

                    schema=retail_husky_public;

[SASKiwi]

That suggests that the connection definition in odbc.ini isn't the same as in your LIBNAME statement. Have you compared them?