SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 13382: The Sybase IQ 12.5 ODBC driver for AIX doesn't work with SAS/ACCESS Interface to ODBC in SAS 9.1.3

DetailsHotfixAboutRate It
The Sybase IQ 12.5 ODBC driver for AIX 64-bit uses 32-bit parameters for
many of the ODBC functions, which causes compatibility problems for
SAS/ACCESS Interface to ODBC on 64-bit Unix platforms.  To workaround
this issue, we will provide new SAS/ACCESS Interface to ODBC engine
modules that are compiled with the unixODBC driver manager.  The
unixODBC driver manager since uses 32-bit parameters for it's ODBC
functions.

The unixODBC driver manager can be downloaded from www.sas.com now :

 Support & Training
   -> Software Downloads
        -> Product & Solution Updates
             -> Redistributable Third Party Software - Drivers

or directly at

http://www.sas.com/apps/demosdownloads/unixODBC_PROD__sysdep.jsp?package
ID=000333


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013382

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013382


After installing the fix, follow the steps below to enable the unixODBC
SAS/ACCESS modules. (assuming that SAS 9.1 is installed in /sas913)

$ cd /sas913/sasexe
$ mv sasodb sasodb.orig
$ ln -s sasodb_u sasodb
$ mv sasioodb sasioodb.orig
$ ln -s sasioodb_u sasioodb
$ mv sasdblda sasdblda.orig
$ ln -s sasdblda_u sasdblda
$ mv sasdblpa sasdblpa.orig
$ ln -s sasdblpa_u sasdblpa
$ mv sasodbcb sasodbcb.orig
$ ln -s sasodbcb_u sasodbcb
$ mv sasodbdb sasodbdb.orig
$ ln -s sasodbdb_u sasodbdb


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to ODBC64-bit Enabled AIX9.1 TS1M39.1 TS1M3 SP1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.