Re: Pivot table over HTTPS
From: Tom Olthoff (tolthoff_at_home.com)
Date: 03/15/04
- Next message: Tom Olthoff: "Re: Percentage Calculation"
- Previous message: Tom Chester: "Re: Percentage Calculation"
- In reply to: Dave Wickert [MSFT]: "Re: Pivot table over HTTPS"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Mar 2004 21:39:17 GMT
Dave,
I have a user that has tried this:
WinXP Pro - with ALL Windows Update patches
- Office 2003 FULL Install
- owc11.exe
- ptsfull.exe
- add website to the list of trusted sites
Still gets the error: Error object does not support this property or method.
PivotControl.Connectionstring.
Any ideas?
I have other users that can access this cube from their workstations.
Regards,
Tom
"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
news:e1hJdrqCEHA.2404@TK2MSFTNGP11.phx.gbl...
> The latest and greatest is on the SQL Server 2000 Analysis Services SP3
> distribution which can
> be found at: http://www.microsoft.com/sql/downloads/2000/sp3.asp
> From the Analysis Services componets (sqlasp3.exe), look in the
> \msolap\install\pts folder.
>
> As I pointed out in the AS Operations Guide
>
(http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.msp
> x) , it is *EXTREMELY IMPORTANT* that you update your client-side PTS
OLEDB
> provider when you upgrade your server to SP3. Many of the performance and
> throughput improvements with SP3 are only realized if you have upgraded
you
> client-side PTS component. This is true with any MSFT and 3rd party
> client-side (or mid-tier) tool -- wherever they are interfacing to PTS,
then
> PTS needs to be upgraded along with the Analysis server.
> --
> Dave Wickert [MS]
> dwickert@online.microsoft.com
> Program Manager
> BI Practices Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "OT Solutions, sales" <OTSolutions@shaw.ca> wrote in message
> news:df21d456.0403150815.4c93d3a6@posting.google.com...
> > Dave, is there any other way to get the pts installed, or is it only
> > off of the SQL Server CD? ie. Office CD as well?
> >
> > Also if the user has Office 2003 is that ok as well?
> >
> > Regards,
> > Tom Olthoff
> >
> >
> > "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
> news:<OVA2M7HCEHA.2628@TK2MSFTNGP11.phx.gbl>...
> > > The client machines must have both OWC (from their Office
> distribution -- XP
> > > preferred) *AND* PTS (from the files ptslite.exe or ptsfull.exe on
your
> SQL
> > > distribution CD).
> > >
> > > --
> > > Dave Wickert [MS]
> > > dwickert@online.microsoft.com
> > > Program Manager
> > > BI Practices Team
> > > SQL BI Product Unit (Analysis Services)
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Tom Olthoff" <tolthoff@home.com> wrote in message
> > > news:bnq4c.789403$ts4.294261@pd7tw3no...
> > > > I have a pivot table on our Internet server that other clients are
> trying
> > > to
> > > > reach via https:.
> > > >
> > > > The pivot table is displayed via the OWC on the server (through ASP
> code).
> > > >
> > > > What do the users need loaded on their machine to access this cube.
> > > >
> > > > I was under the impression (Excel, Pivot Table service, and MS
Query).
> Is
> > > > this correct?
> > > >
> > > > Does OWC need to be installed on the client machine as well?
> > > >
> > > > Some users can connect others cannot. They get an error like:
> > > >
> > > > Pivottable.Connectionstring object doesn't support property.
> > > >
> > > > Any information on this would be greatly appreciated.
> > > >
> > > >
> > > > Regards,
> > > >
> > > > Tom Olthoff
> > > >
> > > >
>
>
- Next message: Tom Olthoff: "Re: Percentage Calculation"
- Previous message: Tom Chester: "Re: Percentage Calculation"
- In reply to: Dave Wickert [MSFT]: "Re: Pivot table over HTTPS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
