Problem with Excel 2000 and OLAP

Ciao,
I have created some cubes in my Analysis Server (SQL2000
Server) and try to retrieve the cube data by Excel2000.
In my own computer, when I create the data source in Excel, I
have not the options for "Microsoft OLE DB Provider for OLAP
Services" and "Microsoft OLE DB Provider for OLAP Services
8.0".

I have installed the Analisys Services..

Can anyone help? Thanks!

FabrizioHi Fabrizio,

below is the step i use retrive cube data from excal 2000.

1) in Excel 2000 click Data --> PivotTable and PivotChart Report
2) in pivot wizard step 1, choose external datasource.
3) click get data
4) click <new datasource> at OLAP CUBE tab
5) select OLAP Provider.
6) select Microsoft OLE DB Provider for Olap Services 8.0
7) click connect --> analysis server --> enter server name
8) it should display a list of OLAP database, select your database & cube.

cheers,
suhfui|||Sorry but I haven't Microsoft OLE DB Provider for Olap Services 8.0.
Why?

Thank you|||You need to install PTSFull (Pivot Table Services) on your client as well.

It can be found in SP3 for Analysis Services in the folder

sql2kasp3\msolap\install\PTS

the 8.0 version is available after that.

HTH Lutz

Problem with displaying image from DB

I am able to write an image to a SQL table. The problem I am having is understanding how to retrieve the image from the table AND display it on a page along with the other page content.

Does anyone have an example or an article to help me with this procedure? I have searched the discussion and read a few articles but they all talk about reading an image into a datagrid which isn't what I want.

Dazed & confused!!!If you can display the image in a datagrid, you can display it by itself too.

Try looking at:
http://authors.aspalliance.com/das/readimage.aspx

That has some code (VB.NET) to show images from a SQL database.

I would recommend reading the other articles linked to that page as well.

You'll probably find that datagrid image code you've already seen will have a hint to the answer.|||I think thats the original page where I got the code to write the image to a database.

As you can see from the link, when they retrieve the image, they either retrieve it in a datagarid or on a page by itself.

It must be a lot harder to pull it into a page with existing data than I can figure out. My hands are tied. All examples are limited to either datagrid examples or a page with only the image and nothing else...ugghhhh!