OPWC error-Object doesn't support this property or method:DSC.ConnectionString

ilona · Feb 24, 2004

We use OWC to provide viewing of OLAP data. Works fine on most client boxes
with Office 2000 or Office XP that access the application. One box w/Office
XP cannot render OWC and gives this error:

"Object doesn't support this property or method:'DSC.ConnectionString'

The same box can connect fine to the OLAP server using Excel Pivot Services.

Would really appreciate any clues or troubleshooting techniques.

Here is the code used in the app:

Sub BindPivot(ptable, dsc)

' Clear any binding there may be

set ptable.DataSource = nothing

' Bind the PivotTable to the DSC

set ptable.DataSource = dsc

ptable.DataMember = scubename

' If we have a saved view, set the XML data for the pivot table

if sxmldata <> "" then

ptable.XMLData = sxmldata

end if

FormatPivotFromStyles ptable

End Sub

Function SetConnection(dsc, fOffline)

' Set the connection string to use an OLAP server

'Provider=MSOLAP.2;Data Source=http://bla-bla-02;Initial Catalog=Foodmart
2000;Roles=All Users;Client Cache Size=25;Auto Synch Period=10000

dsc.ConnectionString = sconnectionstring

' Return success

SetConnection = True

End Function

Thao Moua [ms] · Feb 24, 2004

Verify that machine has OWC10 installed

Thao Mou
OWC Webchart Suppor

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

ilona · Feb 25, 2004

The client machine has Windows XP Ver.2002 SP1, Office XP Pro w/Front Page.
The machine has OWC10.dll installed in C:\Program Files\Common
Files\Microsoft Shared\Web Components\10. It also has MSOWC.dll (OWC9)
installed in C:\Program Files\Microsoft Office\Office 10. The page uses OWC9
as follows:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML>
<HEAD>
<OBJECT id="DSC" classid="clsid:0002E530-0000-0000-C000-000000000046">
<PARAM NAME="XMLData" VALUE='<xml
xmlns:a="urn:schemas-microsoft-com

ffice:access">

<a

ataSourceControl>

<a:OWCVersion>9.0.0.3821</a:OWCVersion>

<a:MaxRecords>0</a:MaxRecords>
<a:GridX>24</a:GridX>

<a:GridY>24</a:GridY>
<a

atamodel version="0816">

</a

atamodel>
</a

ataSourceControl>
</xml>'>
</OBJECT>
<OBJECT id="csetOLAP"
classid="clsid:228136B8-8BD3-11D0-B4EF-00A0C9138CA4">
</OBJECT>

</HEAD>
<body>

<OBJECT id="cspace" style="DISPLAY: inline; WIDTH: 100%; HEIGHT: 60%"
height="384" width="576"
classid="clsid:0002E500-0000-0000-C000-000000000046" name="cspace"
VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-com

ffice:excel">

<x:WebChart>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>

<x:Width>16880</x:Width>
<x:Height>6482</x:Height>

</x:WebChart>
</xml>'>
<PARAM NAME="ScreenUpdating" VALUE="-1">
</OBJECT>
<BR>
</div>

<OBJECT id="ptable" style="LEFT:0px; TOP:0px" height="384" width="518"
classid="clsid:0002E520-0000-0000-C000-000000000046"
name="ptable" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-com

ffice:excel">

<x

ivotTable>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>

<x:CacheDetails/>
</x

ivotTable>
</xml>'>
</OBJECT>

</body>
</HTML>

ilona · Feb 25, 2004

I tried to just instantiate owc 9 on the box w/ a problem using this test
(below) and it fails . Is there a separate install of owc9?

<HTML>
<HEAD>
</HEAD>
<body>

<OBJECT id="DSC" classid="clsid:0002E530-0000-0000-C000-000000000046"
VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:a="urn:schemas-microsoft-com

ffice:access">

<a

ataSourceControl>

<a:OWCVersion>9.0.0.3821</a:OWCVersion>

<a:MaxRecords>0</a:MaxRecords>
<a:GridX>24</a:GridX>

<a:GridY>24</a:GridY>
<a

atamodel version="0816">

</a

atamodel>
</a

ataSourceControl>
</xml>'>
</OBJECT>

<OBJECT id="ptable" height="384" width="518"
classid="clsid:0002E520-0000-0000-C000-000000000046"
name="ptable" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-com

ffice:excel">

<x

ivotTable>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>

<x:CacheDetails/>
</x

ivotTable>
</xml>'>
</OBJECT>

</body>
</HTML>

ilona said:
The client machine has Windows XP Ver.2002 SP1, Office XP Pro w/Front Page.
The machine has OWC10.dll installed in C:\Program Files\Common
Files\Microsoft Shared\Web Components\10. It also has MSOWC.dll (OWC9)
installed in C:\Program Files\Microsoft Office\Office 10. The page uses OWC9
as follows:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML>
<HEAD>
<OBJECT id="DSC" classid="clsid:0002E530-0000-0000-C000-000000000046">
<PARAM NAME="XMLData" VALUE='<xml
xmlns:a="urn:schemas-microsoft-comffice:access">

<aataSourceControl>

<a:OWCVersion>9.0.0.3821</a:OWCVersion>

<a:MaxRecords>0</a:MaxRecords>
<a:GridX>24</a:GridX>

<a:GridY>24</a:GridY>
<aatamodel version="0816">

</aatamodel>
</aataSourceControl>
</xml>'>
</OBJECT>
<OBJECT id="csetOLAP"
classid="clsid:228136B8-8BD3-11D0-B4EF-00A0C9138CA4">
</OBJECT>

</HEAD>
<body>

<OBJECT id="cspace" style="DISPLAY: inline; WIDTH: 100%; HEIGHT: 60%"
height="384" width="576"
classid="clsid:0002E500-0000-0000-C000-000000000046" name="cspace"
VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-comffice:excel">

<x:WebChart>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>

<x:Width>16880</x:Width>
<x:Height>6482</x:Height>

</x:WebChart>
</xml>'>
<PARAM NAME="ScreenUpdating" VALUE="-1">
</OBJECT>
<BR>
</div>

<OBJECT id="ptable" style="LEFT:0px; TOP:0px" height="384" width="518"
classid="clsid:0002E520-0000-0000-C000-000000000046"
name="ptable" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-comffice:excel">

<xivotTable>

ilona · Feb 25, 2004

The client machine w/the problem has Windows XP Ver.2002 SP1, Office XP Pro
w/Front Page.
The machine has OWC10.dll installed in C:\Program Files\Common
Files\Microsoft Shared\Web Components\10. It also has MSOWC.dll (OWC9)
installed in C:\Program Files\Microsoft Office\Office 10.

The app is using OWC 9, which is installed w/Office 2000. The app is
supposed to work w/Office 2000 and XP.
I tried to just instantiate owc 9 on the box w/ a problem using this test
(below) and it fails, while it is successful on the boxes w/no problem. Is
there a separate install of owc9?

<HTML>
<HEAD>
</HEAD>
<body>

<OBJECT id="DSC" classid="clsid:0002E530-0000-0000-C000-000000000046"
VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:a="urn:schemas-microsoft-com

ffice:access">

<a

ataSourceControl>

<a:OWCVersion>9.0.0.3821</a:OWCVersion>

<a:MaxRecords>0</a:MaxRecords>
<a:GridX>24</a:GridX>

<a:GridY>24</a:GridY>
<a

atamodel version="0816">

</a

atamodel>
</a

ataSourceControl>
</xml>'>
</OBJECT>

<OBJECT id="ptable" height="384" width="518"
classid="clsid:0002E520-0000-0000-C000-000000000046"
name="ptable" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-com

ffice:excel">

<x

ivotTable>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>

<x:CacheDetails/>
</x

ivotTable>
</xml>'>
</OBJECT>

</body>
</HTML>

Alvin Bruney [MVP] · Feb 26, 2004

Yes. 2000 uses OWC9. it needs to be installed on the box.
XP uses OWC10 it also needs to be installed on the box.

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

ilona said:
The client machine w/the problem has Windows XP Ver.2002 SP1, Office XP Pro
w/Front Page.
The machine has OWC10.dll installed in C:\Program Files\Common
Files\Microsoft Shared\Web Components\10. It also has MSOWC.dll (OWC9)
installed in C:\Program Files\Microsoft Office\Office 10.

The app is using OWC 9, which is installed w/Office 2000. The app is
supposed to work w/Office 2000 and XP.
I tried to just instantiate owc 9 on the box w/ a problem using this test
(below) and it fails, while it is successful on the boxes w/no problem. Is
there a separate install of owc9?

<HTML>
<HEAD>
</HEAD>
<body>

<OBJECT id="DSC" classid="clsid:0002E530-0000-0000-C000-000000000046"
VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:a="urn:schemas-microsoft-comffice:access">

<aataSourceControl>

<a:OWCVersion>9.0.0.3821</a:OWCVersion>

<a:MaxRecords>0</a:MaxRecords>
<a:GridX>24</a:GridX>

<a:GridY>24</a:GridY>
<aatamodel version="0816">

</aatamodel>
</aataSourceControl>
</xml>'>
</OBJECT>

<OBJECT id="ptable" height="384" width="518"
classid="clsid:0002E520-0000-0000-C000-000000000046"
name="ptable" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-comffice:excel">

<xivotTable>

Using OWC 2000 Pivot in ASP.NET	0	Jan 7, 2006
Pivot Table Authentication Problem	0	May 2, 2008
Recreating charts in ASP page	4	May 10, 2004
Using the pivot table with rds and olap cubes	0	Feb 4, 2004
Generate Pivot table then export to excel	1	Jun 7, 2007
DataSource Control + Read XML Data from Stream	2	Nov 18, 2005
Object doesn't support property or Method 'OWCExcel.Worksheets'	3	Aug 7, 2007
Series and Categories OWC XP v10	1	Dec 21, 2004

OPWC error-Object doesn't support this property or method:DSC.ConnectionString

ilona

Thao Moua [ms]

ilona

ilona

ilona

Alvin Bruney [MVP]

Ask a Question

Similar Threads