Usage Note 33234: An error occurs when you use SAS/ACCESS® Interface to ODBC with a DataDirect ODBC client setup in the UNIX environment
When you use SAS/ACCESS Interface to ODBC with a DataDirect client setup under UNIX, an error message might occur when you use a data source name (DSN) for Oracle:
ERROR: CLI describe error: [DataDirect][ODBC Oracle Wire
Protocol driver]Optional feature not implemented.
The error is caused by certain data types (NCHAR, NVARCHAR2, and NCLOB) that are present in the Oracle table that is being referenced.
To solve this problem, add the EnableNcharSupport=1 option in the section in the odbc.ini file for the DSN that you reference in your LIBNAME statement.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
| HP-UX IPF | 9.1 TS1M3 SP4 | |
| Linux | 9.1 TS1M3 SP4 | |
| Linux on Itanium | 9.1 TS1M3 SP4 | |
| Solaris for x64 | 9.1 TS1M3 SP4 | |
| Tru64 UNIX | 9.1 TS1M3 SP4 | |
*
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.
When you use SAS/ACCESS Interface to ODBC with a DataDirect client setup under UNIX, an error message might occur when you use a data source name (DSN) for Oracle.
| Date Modified: | 2008-09-18 10:02:31 |
| Date Created: | 2008-09-09 15:40:56 |
