| Duncan 2005-09-13, 1:23 pm |
| In my case I had installed Office after the SQL 2005 CTP install. This made
the 8.0 provider (MSOLAP.2) the default MSOLAP provider. In order for Excel
connectivity to AS 2005 to work correctly, MSOLAP.3 (msolap90.dll) needed to
be the default provider.
The solution that worked for me was to re-register "C:\Program Files\Common
Files\System\Ole DB\msolap90.dll".
--
Duncan
"Dave" wrote:
[color=darkred]
> Hi Duncan
>
> I have the same error.
>
> I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
> SQL Server 2005 installed on a server. It seems that I can use most
> combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
> 2005, Excel 2003 will read data from SQL Server 2000 cubes.
>
> But I get the same error as you when I try to read data from SQL Server 2005
> Analysis Services Cubes from Excel 2003. It knows the cubes are there but
> can't read the data.
>
> Did you manage to resolve this? Can anyone else help?
>
> Regards
>
> Dave
>
>
>
> "Duncan" wrote:
>
|