Pivot Table 2003 refresh Client Saftey Options
 

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_O PTIONS_A
LLOW_ALL;

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