Поставили 3 сервис-пак для MS SQL2000

Alexander Rudenko
Дата: 15.10.2003 18:42:46
Ситуация:

Подключаемся к SQL-серверу при помощи OWC (Pivot-Table). До того как поставили сервис-пак все работало нормально. Теперь на запрос

SELECT 'dt' as ww, t1.SUM_ FROM my2003.dbo.Cube_AnTable t1


Получаем:
"Client Safety Options do not allow pass through statements to be issued to the data source."
jimmers
Дата: 16.10.2003 19:41:08
Google gives this:

Release Notes for
IBM Office Connect Analytics Edition
Version 4.0


...

Bug 161796
If you install Microsoft Analysis Service Pack 3 on a computer on which Office Connect is installed, you will receive an error when you export a cube your worksheet or when you retrieve data. The error message you is "Client Safety Options do not allow pass through statements to be issued to the data source." To workaround this issue, close Excel, find the MSRegSec.reg file (under Office Connect installed directory), double-click the MSRegSec.reg file, restart Excel and Office Connect, and export the cube.



Maybe this is your case?