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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Raj More (rm_at_tek.com)
Date: 04/23/04

  • Next message: anonymous_at_discussions.microsoft.com: "Re: how to add spreadsheet control to vb.net" 
    Date: Fri, 23 Apr 2004 17:33:55 -0400

    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: anonymous_at_discussions.microsoft.com: "Re: how to add spreadsheet control to vb.net"

    Relevant Pages

    • Re: accessing data mining model via web/PDA
      ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
      (microsoft.public.sqlserver.datamining)
    • Re: VB Express SQL Express Remote Connection
      ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
      (microsoft.public.dotnet.languages.vb)
    • Re: How to Direct connect with ActiveSync
      ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
      (microsoft.public.sqlserver.ce)
    • .Net Scalability problem
      ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
      (microsoft.public.sqlserver.connect)
    • Re: Communication Link Failure Error
      ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
      (microsoft.public.data.ado)