SQLChamp


Hello,

I'm wondering if anyone could shed some light on the following error when selecting multiple items in a pivot table.

¡°The database driver does not include necessary capabilities and cannot be used with Excel. Contact your database administrator or driver vendor.¡±

Your help is appreciated!




Re: OLAP Error - Excel Pivot

JOER_DK


This is the same error we have now, all started after we got installed Office 2003 SP3, is it the same for you

See my thread bit below yours






Re: OLAP Error - Excel Pivot

SQLChamp

I believe so. I had windows updated last week.

Is this known bug without any patch fix

I have uninstall Office 2003 SP3 then.

-Lawrence






Re: OLAP Error - Excel Pivot

Steppenwolfe

Hiya,

We're having exactly the same problem here. Also, with SP3 recently installed. It was fine before.

So far, I haven't found any other leads as to what's happened.





Re: OLAP Error - Excel Pivot

SQLChamp

Looks like SP3 crashed it. Does anyone know how to uninstall SP3

-Lawrence





Re: OLAP Error - Excel Pivot

JOER_DK

I was wondering what service packs are you guys running for both SQL2005 and AS2005





Re: OLAP Error - Excel Pivot

Nick1977

Hello,

I have gotten the same error. Has anyone found a fix yet Does one have to reinstall Office

Thanks in advance

Nick





Re: OLAP Error - Excel Pivot

JohnEck

Hello,

has anyone found a solution other than reinstalling office 2003 without sp3





Re: OLAP Error - Excel Pivot

h0gg1e

Bumping this back up ... we are having the same problem as everyone else.

Office 2003 SP3
SQL Server 2000 SP4
Analyst Server 2005 (Version 9.00.3042.00)






Re: OLAP Error - Excel Pivot

JOER_DK

We got a mail from microsoft that we should make sure we had installed sp3 for

AS and sp2 for sql2005, but i guess from the last post that it is irrelevant...I guess we have to make a case at microsoft then





Re: OLAP Error - Excel Pivot

Nick1977

Updates anyone

The problem seems to occur when multple selections are made in a row dimension.





Re: OLAP Error - Excel Pivot

JOER_DK

Its different from one dim to another, I have a cube that gives error when a dimnsion is filtered to a single selection...

Come on Microsoft give os some help here!





Re: OLAP Error - Excel Pivot

Nick1977

Has anyone tried this:

Cumulative update package 4 for SQL Server 2005 Service Pack 2

http://support.microsoft.com/default.aspx scid=kb;en-us;941450

I am planning on trying it tonight when few users will be on the network. Has anyone tried this already to see whether it solves the problem





Re: OLAP Error - Excel Pivot

Nick1977

I installed all Microsoft and SQL Server 2005 updates, but the problem still remains.





Re: OLAP Error - Excel Pivot

JOER_DK

We have also installed all patches and service packs, and the problem is still there...

Besides, now we are also having problems with processing cubes after analysis server was patched, but that is another story...