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

From: Sergio A. Lagunes C. (slacas75_at_hotmail.com)
Date: 04/26/04

  • Next message: Alexander P. Brown: "Unexpected Rollup Behavior in OWC10 when ALL Member Formula Used" 
    Date: Mon, 26 Apr 2004 11:50:01 -0500

    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: Alexander P. Brown: "Unexpected Rollup Behavior in OWC10 when ALL Member Formula Used"

    Relevant Pages

    • Re: Connecting to a sql server database
      ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
      (microsoft.public.dotnet.general)
    • Re: Connecting to a sql server database
      ... > line numbered code where the connection string is shown). ... > sql server, hence integrated security fails. ... >> causing the error message and what the correction for this. ...
      (microsoft.public.dotnet.general)
    • Re: Help needed for connecting SQl server from PPC Emulator
      ... watch for the error message in the debuger. ... SqlException.ToString() always return "SqlException" because Message was not ... > I have SQL server 2000 on my desktop PC and SQL instance is registered ... > Connection string but still no difference. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Help needed for connecting SQl server from PPC Emulator
      ... The error message is "SQL server does not exist or access denied". ... the sql server instance does exist coz I am able to connect it through ... >> Connection string but still no difference. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Invalid OLEVERB structure error 80040000 on DTS job
      ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
      (microsoft.public.sqlserver.dts)