I am using ADO to Oracle to feed the PivotCaches for several Pivot
Tables in an Excel workbook. As there is some overhead involved in
opening and closing the connection, I would like to recycle the
connection and reuse it when the user changes a parameter that drives a
necessary refresh to the pivotcache (maintainconnection = true). I
would like to leave the connection open until the application closes.
Is this possible?

Is this possible with an ADO styled connection. I also use Oracle
Objects for OLE to bring data to a workbook but have not been
successful in connecting an Oracle OraDynaset to PivotCache /
PivotTable. Any thoughts here?