CursorLocation parameter and windir/temp folder

09-15-2009, 4:29 AM

Hi,

I'm using DynaCube with Oracle database connecting with DCCT_ADO. Cube application runs on seperate application pool. When cube retrieving data, iis creates temp file to Application Server's windir/TEMP directory. When disk out of space, DynamicCube app pools crashes..


dcLocalCube.DCConnectType = DCConnectTypes.DCCT_ADO;
dcLocalCube.DCConnect = "Provider=OraOLEDB.Oracle;..

I googled and found that setting ConnectionObject.CursorLocation = adUseClient (ADO Client Cursor) causes OraOLEDB to create temp file to windir/TEMP directory. Is there any property of cube use for change connections CursorLocation parameter to Server ?

DynamiCube Version 3.2.1.1177
Oracle 10g r2

Re: CursorLocation parameter and windir/temp folder

09-15-2009, 10:35 PM

Hakan Kutluay,

There is no DynamiCube property which allows you to set CursorLocation. If you need full control of the connection, I would advice you to move DynamiCube to Unbound mode and populate it with values from ADO recordset by using AddRowEx method in Cube's FetchData event.

Thank you,
Andrey T.