Re: OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP
From: Raj More (rm_at_tek.com)
Date: 04/27/04
- Next message: Raj More: "OWC Formatting"
- Previous message: Metsada: "My chart will not open in internet explorer but the file is being made..."
- In reply to: Sergio A. Lagunes C.: "Re: OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP"
- Next in thread: zhoemar_at_telkom.net: "Re: OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 11:09:21 -0400
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
"Sergio A. Lagunes C." <slacas75@hotmail.com> wrote in message
news:O$WMG66KEHA.3704@TK2MSFTNGP11.phx.gbl...
> 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" <rm@tek.com> escribió en el mensaje
> news:OX3AYpXKEHA.624@TK2MSFTNGP11.phx.gbl...
> > 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.
> >
> > "zhoemar" <zhoemar@telkom.net> wrote in message
> > news:30f101c428e2$dbc88cd0$a401280a@phx.gbl...
> > > 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
> > > Info=True;Data Source= <%=sServer %>
> > > Username=OWC;Password=XXXXX;Initial Catalog=<%=sDatabase %
> > > >"
> > > pt.DataMember = "<%= sCube %>"
> > >
> > > Why doesn't the Username=OWC;Password=XXXXX; part work?
> >
> >
>
>
- Next message: Raj More: "OWC Formatting"
- Previous message: Metsada: "My chart will not open in internet explorer but the file is being made..."
- In reply to: Sergio A. Lagunes C.: "Re: OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP"
- Next in thread: zhoemar_at_telkom.net: "Re: OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
