Unable to query a SAP HANA database: Driver error – 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet

Symptom

Unable to query a SAP HANA database, the following error occurs:

Driver error - 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet

Cause

The SAP HANA ODBC layer does not support scrollable cursors.

Resolution

Go to the global configuration properties for the SAP HANA ODBC connection via:

Manage -> Tools -> Input -> Database Query (ODBC)

  • Select the SAP HANA connection and click on Properties
  • Select the Cursors tab
  • Change the option from Advanced cursor attributes;
    1
  • To Basic forward only
    2