Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: OLE DB provider for OLAP Services 8.0 Missing
We are introducing office web components to query an OLAP
data cube via EXCEL and ASP.NET, but on some machines this doesn't work. Ive tracked this back to an excel issue. If I go into excel and click Data, external data and new database query, then I choose OLAP Cubes, double click on new data source, put in a name and click the drop down box to specifiy an OLAP provider. On the machines that fail this box is blank. On all the machines that work the box gives me at least one option to provide a OLAP Provider i.e (Microsoft OLE DB Provider for OLAP Services 8.0). I've searched the web high and low and can't find anyone with the same issue yet I've found this on 2 out of 5 machines in a test group. Please advise If you can tell me a way to add in this functionality then I think this will fix the issue. Thanks Nigel Roach |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: OLE DB provider for OLAP Services 8.0 Missing
Nigel,
Maybe dependent on the version of MDAC installed ? http://support.microsoft.com/kb/301202 NickHK "nigeaman" wrote in message ... We are introducing office web components to query an OLAP data cube via EXCEL and ASP.NET, but on some machines this doesn't work. Ive tracked this back to an excel issue. If I go into excel and click Data, external data and new database query, then I choose OLAP Cubes, double click on new data source, put in a name and click the drop down box to specifiy an OLAP provider. On the machines that fail this box is blank. On all the machines that work the box gives me at least one option to provide a OLAP Provider i.e (Microsoft OLE DB Provider for OLAP Services 8.0). I've searched the web high and low and can't find anyone with the same issue yet I've found this on 2 out of 5 machines in a test group. Please advise If you can tell me a way to add in this functionality then I think this will fix the issue. Thanks Nigel Roach |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: OLE DB provider for OLAP Services 8.0 Missing
Hi ,
How is everything going? Please feel free to let me know if you need any assistance. Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query (Excel 2007) - OLAP-Function is missing | Setting up and Configuration of Excel | |||
"OLE DB Provider for Microsoft Directory Services" | Excel Discussion (Misc queries) | |||
OLE DB Provider and Excel | Excel Programming | |||
Error connecting to OLAP 2000 through Analysis Services addin Exce | Excel Programming | |||
Excel Macro for building up OLAP CUBES - Analysis Services | Excel Programming |