topic HP-UX Problem with SAS Access to MS SQL in Administration and Deployment

HP-UX Problem with SAS Access to MS SQL

MariaD — Wed, 19 Jul 2017 16:10:44 GMT

Hi all,

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

Any idea?

Re: HP-UX Problem with SAS Access to MS SQL

MariaD — Wed, 19 Jul 2017 17:00:42 GMT

Hi all,

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:

/sas9/software/AccessClients/9.4/SQLServer/lib/S0msss27.so

Re: HP-UX Problem with SAS Access to MS SQL

MariaD — Wed, 19 Jul 2017 17:08:33 GMT

Hi all,

change for "S0sqls27.so" driver and now connect without error. Thanks!