07-19-2017 12:10 PM
I've just finished to install SAS 9.4 on a HP-UX server. As per detailed on configuration document, http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf, I setting the ODBCHOME environment variable and edit the odbc.ini.
After that, when I tried to define a SQL Server library, the following error appear:
ERROR: Could not load /sas9/software/SASFoundation/9.4/sasexe/sassqsrv (98 images loaded)
ERROR: Unable to find library 'libodbc.so'.
I verify and the 'libodbc.so' is located on "/sas9/software/AccessClients/9.4/SQLServer/lib". The currents environments variables are:
$ echo $ODBCHOME
$ echo $ODBCINI
$ echo $SHLIB_PATH
07-19-2017 01:00 PM
An update about this problem. I added the environment variables definition on sasenv_local file <SASHOME>/SASFoundation/9.4/bin.
Now, the error changed when I execute the libname statement. The new error is:
ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]
ERROR: Error in the LIBNAME statement.
I'm using the following driver on odbc.ini file:
Need further help from the community? Please ask a new question.