Pivot Table 2003 refresh Client Saftey Options

G

Guest

All,

I have created some offline cubes programaticaly through
exel and I am trying to refresh them. I keep getting an
error saying that the Client Safety options do not allow
pass through queries. This seems to only be a problem
with excel 2003, I understand it to be a new safety
options. I have tried putting

DBPROP_MSMD_SAFETY_OPTIONS=DBPROPVAL_MSMD_SAFETY_OPTIONS_A
LLOW_ALL;

in the connection string, however that does not seem to
work. Can anyone please help, thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Client Safety Options Problem 0
Client Saftey Option in Excel 2003 0
Pivot tables not refreshing after data source update 1
Refreshing Pivot table 1
refresh multiple pivot tables in workbook 2
Hooking into Refresh/RefreshAll events from listobject 3
Disabling the refresh of a pivot table 0
Pass a command text in pivot table 0

Top