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/sas9/software/AccessClients/9.4/SQLServer$ echo $ODBCINI/sas9/software/AccessClients/9.4/SQLServer/odbc.ini$ echo $SHLIB_PATH/sas9/software/AccessClients/9.4/SQLServer/lib:/oracle/app/oracle/product/11.1.0/client_1/lib
change for "S0sqls27.so" driver and now connect without error. Thanks!
View solution in original post
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:
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.