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
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
SAS System | SAS/ACCESS Interface to ODBC | 64-bit Enabled AIX | 9.1 TS1M3 | 9.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.
Type: | Usage Note |
Priority: | medium |
Date Modified: | 2006-05-02 14:42:48 |
Date Created: | 2004-09-22 09:35:38 |