Architecting, installing and maintaining your SAS environment

HP-UX Problem with SAS Access to MS SQL

Accepted Solution Solved
Reply
Contributor
Posts: 59
Accepted Solution

HP-UX Problem with SAS Access to MS SQL

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?


Accepted Solutions
Solution
‎07-19-2017 01:11 PM
Contributor
Posts: 59

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

Hi all,

 

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

View solution in original post


All Replies
Contributor
Posts: 59

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

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

Solution
‎07-19-2017 01:11 PM
Contributor
Posts: 59

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

Hi all,

 

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 257 views
  • 0 likes
  • 1 in conversation