Retrieve recordset

[Markus Stehle]

Hi all!

I'm using OWC10 within an asp.net page. I'm creating a pivot table
programmatically and I'd like to retrieve the recordset that represents the
ActiveData of the pivot table. But when calling rs =
pivot.ActiveData.RecordSet I get an unspecified error.

Does anybody know what might be wrong?


Thanks

Markus

 

[Dan Ricker]

Without seeing the code, it's pretty hard to guess.

If you are using an MSOLAP data source, then there is no
RecordSet. Attempting to retrieve the recordset raises
Error: -2147467259 (No Description with the error).

 

[Dan Ricker]

Something from a thread on a similar issue...

A couple of things to make sure of... Make sure the
anonymous user account has read, write create and delete
access to the folder where the database resides AND to the
System Environment Temp folder. Those are usually the two
big things that will give you problems with Access in ASP
pages... Another thing to do is to run Filemon and see
what other folders may be lacking permission and possibly
Regmon (though with the Jet provider that is usually less
likely than if it was using ODBC)