How to disable scrollable cursor in OBI EE?
703858May 27 2009 — edited May 29 2009Hi, i'm using OBI EE 10.1.3.2 and did some simple quey by just selecting 3 columns without any grouping whatsoever from our datamart on postgresql 8.2. Somehow OBI EE generate a scrollable cursors and generate ODBC error that say the database didn't support a scrollable cursors. We cannot upgrade the database so we need to do something with OBI EE.
Do you know how to disable OBI EE to generate a scrollable cursors ? i check the OBI EE Administration and go to the tab (in the physical layer) with "ask dbms" button and cannot find any cursors setting. It is a normal SELECT so i don't need a scrollable cursors.
thank you before