OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP

[zhoemar]

I am creating an ASP page in which an OWC Pivot Table is
embedded that references an OLAP cube. I am a newbie with
this control, and borrowed most of the code from the MS
Office Web Components Toolpack.

What I have seems to always pass the Windows username &
Password of the user to the OLAP server for authentication
(Data Source Logon dialog box). What I want is to specify
a username & password is the code such that all users
connect using the same one.

(By the way, the reason for this is that the page will be
deployed on a company intranet that is accessible across
many NT domains, and I can't figure any other way to work
around the fact that the MS Analysis server (2000) can
only recognise accounts in the domain it is in. If anyone
knows an answer to this, I want to know!)

My connection string is set up like this:

pt.ConnectionString = "Provider=MSOLAP.2;Persist Security

"

pt.DataMember = "<%= sCube %>"

Why doesn't the Username=OWC;Password=XXXXX; part work?

 

[Raj More]

Zhoemar,

The one thing I have found is that SQL Server and Analysis server, both must
be installed on the host machine that you are connecting to.

Create a Login in SQL Server that has access to the Master database, and use
that login in your connection string. I use connection strings that look
like this:

Me.AxPivotControl.ConnectionString="Provider=MSOLAP.2;Persist Security
Info=False;Data Source=__MYSERVERNAME;Location=master;Initial
Catalog=__MYDATABASENAME;Client Cache Size=25;Auto Synch Period=10000;User
ID=__MYUSERNAME;Password=__MYMYPASSWORD"

Me.AxPivotControl.DataMember="__MYCUBENAME"

It works for me.

Raj More.

 

[Sergio A. Lagunes C.]

Hi

I have similar error, the client machine display error message inside the
component:
Can not connect to data

I try your example, but continue with the same error message.

Can't you help me??

Thanks

 

[Raj More]

Sergio,

Are you able to connect from the client machine to the server using the
Analysis Manager? Do you have network connectivity to the server?

Raj More

 

[Guest]

Great thank you Mr Raj More..
Your script works for me too....