GET DATA fails with error "Optional Feature Not Implemented"

Technote (troubleshooting)


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

Document information

More support for:

SPSS Statistics

Software version:

21.0, 22.0

Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation