After the installation of SP3 SQLServer 2000,

when I try to update a pivotTable from a cube, Excel send this message:

"Client Safety Options do not allow pass through statements to be issued
to the data source" .

The content of .OQY file is:

"

QueryType=OLEDB

Version=1

CommandType=Cube

Connection=Provider=MSOLAP;DATA SOURCE=\\Server01\ANA.cub;Initial
Catalog=ANA;Client Cache Size=25;Auto Synch Period=10000

CommandText=ANA

"

The INSERT statement in the .cub contains the PASSTHROUGH option, but

I can't change this.



What can I do?



Thanks, Andrea


--
Posted via http://dbforums.com

Hi Andrea,

Excel security is controlled by a registry value, in the
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\<Offic e Version>\Excel\Options
registry key.

You should be able to enable passthrough functionality by adding the values
below to the HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\<Offic e
Version>\Excel\Options registry key.

Value Name OLAPUDFSecurity
Data Type REG_DWORD
Value 1

The value 1 allows any DLL to run (note using this setting security is low
and any user defined function is allowed to pass through, which may present
a security risk).

The value 2 only allows DLLs marked as safe for scripting to be executed.
The value 3 does not allow any UDF to run.

The default value (if not present) is 2.

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

This did not work for me.

Using Office 2000, Windows 2000 Pro

Error appears when trying to refresh Excel cube data


"Bas Kersten [MSFT]" wrote: