Hi experts!
I'm executing a sas program from linux command line, example:
/sas94/sashome/SASFoundation/9.4/sasexe/sas program.sas
I have to assign a libname to connect a sql server database to obtain the data, but I have this problem
ERROR: Could not load /sas94/sashome/SASFoundation/9.4/sasexe/sasodb (32 images loaded) ERROR: /sas94/sapiq160/IQ-16_0/lib64/libodbc.so: version `VERS_3.52' not found (required by /sas94/sashome/SASFoundation/9.4/sasexe/sasodb) 1 LIBNAME SAMPLE2 ODBC NOPROMPT="Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1;SERVER=999.99.9.999,8888; 1 ! DATABASE=example1;UID=usr_XX; 2 PWD=ABCD" SCHEMA=dbo; ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code appendage could not be loaded. ERROR: Error in the LIBNAME statement.
I also have tried this: LIBNAME SAMPLE2 ODBC DATAsrc=NAMESRC_S SCHEMA=dbo USER=usr_XX PASSWORD="{SAS222}828A4PP5CB131A25BC" ;
and I obtain the same error.
BUT, when I do it from SAS enterprice Guide, both libname staments work fine!
any idea?
... View more