MS SQL Server OLAP - Excel OLE DB Connection

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Excel OLE DB Connection

Baerbel Zimmermann

2006-01-26, 4:58 pm

Hi,

I have a SQL Server 2005 Database with AS 2005 cubes and as Front End I
use Excel 2003 via OLE DB 9. Anything works fine.
Now I want to install all the components (database, cubes and Excel
Front End) at another PC. SQL Server and Analysis database are no
problem. But the Excel Front End doesn’t find the connection to the
Analysis database. The names are equal to the other server. Is it
anywhere possible to define or assimilate the connection?

Thanks
Bärbel

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links