Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duncan - 09 Aug 2005 16:50 GMT

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:

"Initialization of the data source failed.

Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database. "

Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.

Thanks,

Signature

Duncan

Reply to this Message

Dave - 13 Sep 2005 13:51 GMT

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

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
> the wizard successfully finds and connects to the cube, but when I click
[quoted text clipped - 10 lines]
>
> Thanks,

Reply to this Message

Duncan - 13 Sep 2005 17:47 GMT

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".

Signature

Duncan

> Hi Duncan
>
[quoted text clipped - 30 lines]
> >
> > Thanks,

Reply to this Message

Dave - 16 Sep 2005 11:25 GMT

That works for me too.

Thanks!

Dave

> 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
[quoted text clipped - 38 lines]
> > >
> > > Thanks,

Reply to this Message

hpanneflek - 09 May 2006 18:02 GMT

If you found a solution, please let me know. I'm getting the same error
message.

Thanks a lot.

> *When I use the PivotTable Wizard in Excel 2003 to connect to a SQL
> 2005 cube,
[quoted text clipped - 18 lines]
> --
> Duncan *

--
hpanneflek

Reply to this Message

Daffyd - 11 May 2006 12:07 GMT

> *If you found a solution, please let me know. I'm getting the sam
> error message.
>
> Thanks a lot. *

I got around this by re-registering the OLAP v9.0 dll:

regsvr32 c:\program files\common files\system\oledb\msolap90.dll

This worked for me.

Good luck

Dav

-
Daffy

Reply to this Message

hpanneflek - 11 May 2006 14:56 GMT

Thank you! It worked.

I've been using AS 2K for 3 years now and I love it. I started playing
with AS2K5 and I am realizing that a lot of things changed. My email is
hpanneflek@univision.net in case you have any question, I'll be glad to
help.

Thanks again.

> *I got around this by re-registering the OLAP v9.0 dll:
>
[quoted text clipped - 5 lines]
>
> Dave *

--
hpanneflek

Reply to this Message