The following errors can occur when you use SAS/ACCESS Interface to ODBC to access a Sybase IQ 12.x database.

ERROR: Could not load /sasinst/SASFoundation/9.2/sasexe/sasodb (61 images loaded)
ERROR: Unsatisfied code symbol 'SQLPrepareW' in load module '/sasinst/SASFoundation/9.2/sasexe/sasodb'.
libname libodbc ODBC DSN=SYBDSN;
ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.

The errors occur in SAS 9.1.3 if you have applied Hot Fix E90D05 or later fixes, and they also occur in SAS 9.2.

Note: Instead of SQLPrepareW, the messages might reference SQLDescribeColW.

This error can result if the library path in a UNIX environment is set to reference the driver manager (libodbc.xx) that is supplied by Sybase IQ first. The driver manager in Sybase 12.x does not handle ODBC-compliant wide character calls that are introduced in Hot Fix E90D05 for SAS/ACCESS 9.1.3 Interface to ODBC. This issue carries over into SAS/ACCESS 9.2 Interface to ODBC.

You can correct this problem in either of the following ways:

• Upgrade from Sybase IQ 12.x to Sybase IQ 15.x. The supplied driver manager (libodbc.xx) in Sybase IQ 15.x can handle the ODBC wide character calls.
• Use the driver manager in unixODBC 2.2.14 or later. You can download the free driver manager from the unixODBC Web site. After you have downloaded it, set the library path to reference the unixODBC driver manager (libodbc.xx) first.

Operating System and Release Information