Client safety options do not allow pass through statements to be issued ...

[Hugh V]

I have pivottables embedded in html pages that create and
use local cubes (via msolap.2) using a local csv file as
the data source via the Microsoft Text driver.

After installing Office 2003, the pages that use the XP
version of the web component will load, but when I
attempt to refresh the data (!) the following message box
is displayed:

"Run-time error '16389'
Client Safety Options do not allow pass through
statements to be issued to the data source."

A page that uses the Office 11 (2003) version of the
component does not load at all, with the same message
being issued.

I have tried adding "Safety Options=1" to the connection
string. This alleviates the problem but does not cure
it. I can now load and refresh the page once. The
second attempt to refresh results in the same error
message.

Can anybody tell me how/where I can set the client safety
options so that the web components in my pages behave
correctly?

 

[Hugh V]

If anyone is interested, I resolved this by changing the
form of the SELECT statement in the source clause of my
INSERT INTO statement.

The SELECT was in the form:

select field1, field2, ... from table

I changed it to:

select T0.field1, T0.field2, ... from table as T0

This completely resolved this issue for my case. I
believe that Pivottable Service was unable to parse the
first form of the statement, making the use of OPTIONS
ATTEMPT_ANALYSIS ineffective, and causing it to revert to
PASTHROUGH mode. Therefore it became subject to the new
security measure implemented in SQL Server 2000 SP3a and
installed with Office 2003.

If you actually want or need to use PASSTHROUGH mode,
then I'm afraid I can't help - I still don't know how you
can override the "client safety options" to permit this
with local cubes.

I hope this information is of some help to somebody.