Problem Note 47004: Using Sybase IQ 15.4 with SAS/ACCESS® Interface to Sybase IQ might result in a missing module and a subsequent error
 |  |  |  |
If you try to access a Sybase IQ server using SAS/ACCESS Interface to Sybase IQ, the following error might result:
ERROR: The SAS/Access Interface to SYBASEIQ cannot be loaded. The SASIQ code appendage could not be loaded. Check the SAS Log for possible additional information. ERROR: Could not load /opt/SASHOME/SASFoundation/9.3/sasexe/sassiq ERROR: ld.so.1: sas: fatal: libdbodbc11.so: open failed: No such file or directory
With the release of Sybase IQ 15.4, the module libdbodbc12.so replaces the module libdbodbc11.so.
Workaround for Solaris Only
To circumvent this issue, create a soft link for the Sybase IQ client between the new module, libdbodbc12.so, and the module that SAS is expecting to find, libdbodbc11.so. Create the link by using the following command at the UNIX command prompt, as shown below:
unix_prompt> ln -s libdbodbc12.so libdbodbc11.so
A fix for this issue is planned for a future software release. All platforms other than Solaris will need this fix, after which a workaround will not be needed.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Sybase IQ | 64-bit Enabled AIX | 9.3_M1 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.3_M1 | 9.3 TS1M0 | ||||
| HP-UX IPF | 9.3_M1 | 9.3 TS1M0 | ||||
| Linux | 9.3_M1 | 9.3 TS1M0 | ||||
| Linux for x64 | 9.3_M1 | 9.3 TS1M0 | ||||
| Solaris for x64 | 9.3_M1 | 9.3 TS1M0 | ||||
SAS/ACCESS Interface to Sybase IQ fails to load because of a missing module.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Sybase IQ |
| Date Modified: | 2012-07-30 11:40:37 |
| Date Created: | 2012-07-16 11:33:51 |