BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MariaD
Barite | Level 11

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?

1 ACCEPTED SOLUTION

Accepted Solutions
MariaD
Barite | Level 11

Hi all,

 

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

View solution in original post

2 REPLIES 2
MariaD
Barite | Level 11

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

MariaD
Barite | Level 11

Hi all,

 

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

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.

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