Re: ADOMD Connection
- From: "Shailesh" <Shailesh@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 03:41:03 -0700
Hi Dave,
I need to convert cellset into XML formated data, so that I can view the
result in ChartSpace. Can u guide me what is the similar method for cellset
as dataset.writexml()?
Thanking you.
Shailesh.
"Dave Wickert [MSFT]" wrote:
> Analysis Services only supports NT integrated security. It does not have the
> similar concept as what SQL Server RDBMS calls "standard secruity". The
> nearest thing that we have is that if you use http access, you can specify
> the uid/pwd in the connection to specify what login to use against IIS with
> basic or digest authentication. In that case, the uid/pwd is for the NT
> account to use against IIS.
>
> There are several resources which talk about this. Besides BOL, see the
> following two white papers,
>
> SSAS Operations Guide:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
> (in the section titled "Security Administration"
>
> Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.asp
>
> Hope that helps.
> --
> Dave Wickert [MSFT]
> dwickert@xxxxxxxxxxxxxxxxxxxx
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ale Dori" <AleDori@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:ED4592C1-8480-4DB8-A025-61E7F139B871@xxxxxxxxxxxxxxxx
> > I need to connect with ADOMD to an OLAP DB.
> >
> > I want to specifide the user name and password in the connection string in
> > the let_ActiveConnection property as follows:
> >
> > Provider=MSOLAP;Password=pippo;Persist Security Info=True;User
> ID=pluto;Data
> > Source=MyServer;Initial Catalog=MDX30;Client Cache Size=25;Auto Synch
> > Period=10000
> >
> > I receive a generic error massage.
> >
> > If I try to connect without User ID and Password it work correctly.
> >
> > Any ideas??
> >
> > Thanks you
> >
>
>
>
.
- Prev by Date: Re: Error processing cube with disabled lowest level of shared dimension
- Next by Date: RE: Getting only leaf members
- Previous by thread: Copy/Paste Error
- Next by thread: PeriodsToDate in a flat time dimension
- Index(es):
Relevant Pages
|
