Hi experts,
when i assign a library in SAS environment EG, there's no problem using this syntax :
libname NAMEXXX SYBASEIQ DATABASE=PRODT SERVER=XXPROD PORT=9999 HOST=XXXPROD SCHEMA=DBO
USER=XXXXXXX07 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
But when i try to use it in linux invironment (executing a sas program from linux) example:
[user@promt]$ /sas94/sashome/SASFoundation/9.4/sasexe/sas /sasxxx/temp/L1.sas
I get this error :
ERROR: Could not load /sas94/sashome/SASFoundation/9.4/sasexe/sassiq (33 images loaded)
ERROR: libdbodbc16.so: cannot open shared object file: No such file or directory
1 libname NAMEXXX SYBASEIQ DATABASE=PRODT SERVER=XXXXX_PROD PORT=9999 HOST=XXXXXXPROD SCHEMA=DBO
1 ! USER=XXXXXXX07 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
ERROR: The SAS/ACCESS Interface to SAPIQ cannot be loaded. The SASSIQ code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
ERROR: Errors printed on page 1.
This only happens when the library has a conections with the database sybaseiq.
when i assign a library like this libname namelib base "/sasxxx/folder"; it works fine
Hi Guys i got this solution:
To work-around this error you can create a soft link in the same directory as the libdbodbc16.so file.
ln -s libdbodbc16.so libdbodbc12.so
should result in :
libdbodbc12.so -> ./libdbodbc16.so
and then the Sybase IQ should work as expected.
And don´t forget to check the library path !
Looks like the SYBASEIQ engine is not properly installed on that version of SAS.
Check with your local support team.
Since you running metadata-enabled SAS servers - you have to be to be using EG - I would expect that you would run SAS batch jobs from your configured SAS batch server directory to ensure you pick up the correct SAS configurations. In Windows it looks like this:
\SAS\Config\Lev1\SASApp\BatchServer\sasbatch.bat
But it is probably something similar on linux with forward slashes.
Thks Guys, i guess the problem is refer to :
This is caused by the Linux loader not loading a dependency of the major version number that differs from the version number at load time.
To work around this issue, use Sybase IQ version 15.4.
Hi Guys i got this solution:
To work-around this error you can create a soft link in the same directory as the libdbodbc16.so file.
ln -s libdbodbc16.so libdbodbc12.so
should result in :
libdbodbc12.so -> ./libdbodbc16.so
and then the Sybase IQ should work as expected.
And don´t forget to check the library path !
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.