From 50deb8cf70f61e21fb0c35182341477af11adbc1 Mon Sep 17 00:00:00 2001 From: Joachim Puhr Date: Mon, 8 Jan 2018 16:50:30 +0100 Subject: doc: Hints for using SAP HANA database As the HANA ODBC driver does not provide scrollable results per default, the connection has to be established with a specific option. Change-Id: I14751a94f61d6fffd6d56c39076c24ec4d1f88ef Reviewed-by: Edward Welbourne Reviewed-by: Joachim Puhr Reviewed-by: Andy Shaw --- src/sql/doc/src/sql-driver.qdoc | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'src/sql/doc/src/sql-driver.qdoc') diff --git a/src/sql/doc/src/sql-driver.qdoc b/src/sql/doc/src/sql-driver.qdoc index 025cd43ef7..44acb79c46 100644 --- a/src/sql/doc/src/sql-driver.qdoc +++ b/src/sql/doc/src/sql-driver.qdoc @@ -299,6 +299,12 @@ e.g., the SQLSTATEs. Before setting this connect option, consult your ODBC documentation about behavior differences you can expect. + When using the SAP HANA database, the connection has to be + established using the option "SCROLLABLERESULT=TRUE", as the + HANA ODBC driver does not provide scrollable results by default, e.g.: + + \snippet code/doc_src_sql-driver.cpp 35 + If you experience very slow access of the ODBC datasource, make sure that ODBC call tracing is turned off in the ODBC datasource manager. -- cgit v1.2.3