GET DATA fails with error "Optional Feature Not Implemented"

Technote (troubleshooting)


Problem(Abstract)

Customer is trying to GET DATA TYPE ODBC from his Oracle database using the last IBM SPSS OEM 7.1 drivers but it is failing with the following error:

Warning. Command name: GET DATA
SQLExecDirect failed :[IBM SPSS][ODBC Oracle Wire Protocol driver]Optional feature not implemented.

Resolving the problem

In the select statement, you are importing some variables of TYPE NVARCHAR2.

Checking the "Enable N-CHAR Support" option in the advanced tab of the ODBC configuration solved the issue:

Windows Startup > Administrative tools > Data Source ODBC > Select the right DSN and click on Configure > Advanced Tab


Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics

Software version:

21.0, 22.0

Operating system(s):

Windows

Reference #:

1653237

Modified date:

2013-10-16

Translate my page

Machine Translation

Content navigation