OWC not working in VISTA IE7 version

A

Angelo

It's Obvious !!! IN web dev that OWC not working in VISTA IE7
version.
What will do know ?
Any solution ?
 
M

MomentumDev

Hi Angelo,

Which OWC version do you think does not work with IE7 and VISTA? I
this all versions of OWC or a specific one? We have a product that use
all versions of OWC (9 10 and 11). If none of them work, then it will b
disastrous for me? Could you specify as to what does not work in OWC
Also, did you get any reply from anyone or from microsoft support?

I do not yet have VISTA installed for testing, I would do that shortly
but could you please say some more on this issue...

Thanks in advance,
MomentumDe
 
A

Angelo

MomentumDev Hi,
Unfortunatelly is for all - 9.10.11 versions
Vista installed (for test purposes- in one pc which is in a central
domain) both with MSO2007 and IE7.
IE7 with any windows enviroment seems works with no problem but with
vista cracks!!!
Finally i can't resolve if cracks without MSO2007 or with it ... I
will make more test in future

Noone sent something relevant on this also M$ not yet answer !!!
 
M

MomentumDev

Hi Angelo,

Thanks for your quick response. Actually which component of OWC are yo
using? Is this PivotControl or Spreadsheet or Chart or All of them.

Because, surprisingly Microsoft, on there web-site(OWC11 downloa
page), mention Windows Vista as the supported OS.

I use PivotControl and Chart and Spreadsheet all of these in m
implementation, so it would be helpful to know which ones you hav
tested and what really failed in your testing.

Thanks,
MomentumDe
 
A

Angelo

It's PivotControl . I also use an .htm from access for another easy
try and go like this.
I try it with OWC.10.0.0.5605 (best fit) .... But the results was the
same !!!

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:eek: =
"urn:schemas-microsoft-com:eek:ffice:eek:ffice" xmlns:x =
"urn:schemas-microsoft-com:eek:ffice:excel" xmlns:a =
"urn:schemas-microsoft-com:eek:ffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Sales</
TITLE><LINK
href="Sales_files/filelist.xml" type=text/xml rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html;
charset=windows-1253">
<META content=10.00.3420 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM
NAME="XMLData" VALUE='<xml xmlns:a="urn:schemas-microsoft-
com:eek:ffice:access">
<a:DataSourceControl>

<a:OWCVersion>10.0.0.5605 </a:OWCVersion>

<a:MaxRecords>10000</a:MaxRecords>
<a:GridX>10</
a:GridX>
<a:GridY>10</a:GridY>
<a:OfflineType>2</
a:OfflineType>
<a:XMLLocation>0</a:XMLLocation>

<a:XMLDataTarget></a:XMLDataTarget>
<a:ConnectionFile></
a:ConnectionFile>
<a:Datamodel a:version="0816">

</a:Datamodel>
</a:DataSourceControl>
</xml>'></
OBJECT>
<META content="MSHTML 6.00.2900.3020" name=GENERATOR>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH:
2.539cm; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.396cm;
TEXT-ALIGN: left
}
..MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW:
hidden; WIDTH: 2.539cm; FONT-FAMILY: Tahoma; HEIGHT: 0.502cm
}
..MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-
BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
..MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand;
BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
..Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden;
POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
..Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT:
normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR:
url(#DEFAULT#Mso2dSectionBanner); OVERFLOW: visible; PADDING-TOP: 2px;
FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT: 0.507cm; BACKGROUND-COLOR:
buttonface
}
..MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW:
hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
..MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
..MsoExpandCollapse {
CURSOR: hand
}
..MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; Z-
INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-
BOTTOM: gainsboro 1px solid; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
..MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM:
gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
}
..MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid;
BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid;
BACKGROUND-COLOR: buttonhighlight
}
..MsoNavToggleButtonMouseOver {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
solid; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM:
buttonshadow 1px solid; BACKGROUND-REPEAT: no-repeat; BACKGROUND-
COLOR: buttonshadow
}
..MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-
BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
..MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT:
gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px;
BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma; POSITION:
relative
}
..MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-
BOTTOM: buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR:
gainsboro
}
..MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/
#11240); BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/
#11241); BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px
solid; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%;
BACKGROUND-COLOR: buttonshadow
}
..MsoRecordSelectorDirtyCurrent {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/
#11242); BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/
#11245); BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; TOP: 0px
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
</STYLE>

<SCRIPT language=Javascript id=MSODSC_Validation>
validateBrowser();

function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" &&
intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0
height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15>&nbsp;</
TD><TD bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white><b>&nbsp;Data Access Page
Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15>&nbsp;</TD><TD
bgColor='#cccccc' width=500px><BR>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a href='http://www.microsoft.com/isapi/redir.dll?
Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p
align='center'>"
strMsgGetIE+="Click here to install the latest version of Internet
Explorer.</a></font></p><br></TD></TR></TABLE>"
document.write(strMsgGetIE)
}
}

function validateOWC() {
if (MSODSC.object==null) {
strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0
border=0 height='8'>"
strMsgGetOWC+="<TR><TD bgColor='#336699' height=25 width=15>&nbsp;</
TD><TD bgColor='#666666' width=500px>"
strMsgGetOWC+="<FONT face=Tahoma color=white size=4><B>&nbsp;&nbsp;"
strMsgGetOWC+="Data Access Page Notification</B></FONT></TD></
TR><TR><TD bgColor='#cccccc' width=15>&nbsp;</TD>"
strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'><BR>"
strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires
the Microsoft Office Web Components.</p>"
strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a
HRef='http://r.office.microsoft.com/r/rlidmsowcpub?
clid=1033&p1=Microsoft Access&HelpLCID=1033'>Microsoft Office Web
site</a> for more information. "
strMsgGetOWC+="</font></p><BR></TD></TR></TABLE>"
document.write(strMsgGetOWC)
}
}

</SCRIPT>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>project_manager</o:Author>
<o:LastAuthor>project_manager</o:LastAuthor>
<o:Revision>9</o:Revision>
<o:TotalTime>19</o:TotalTime>
<o:Created>2007-02-06T09:40:25Z</o:Created>
<o:LastSaved>2007-02-07T13:24:55Z</o:LastSaved>
<o:Company>Sprider</o:Company>
<o:Version>11.5606</o:Version>
</o:DocumentProperties>
</xml><![endif]--></HEAD>
<BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
<CENTER>
<H1 class=MsoTitle id=HeadingText>&nbsp;</H1></CENTER>
<P>
<OBJECT id=PivotTable2
style="Z-INDEX: 1; LEFT: 10px; WIDTH: 502px; TOP: 73px; HEIGHT:
333px"
tabIndex=1 height=333 width=502
classid=CLSID:0002E552-0000-0000-C000-000000000046><PARAM
NAME="XMLData" VALUE="<xml xmlns:x=&quot;urn:schemas-microsoft-
com:eek:ffice:excel&quot;>
<x:pivotTable>

<x:OWCVersion>10.0.0.5605 </x:OWCVersion>

<x:CubeProvider>msolap.2</x:CubeProvider>
<x:DisplayFieldList/>
<x:FieldListTop>283</
x:FieldListTop>
<x:FieldListLeft>585</
x:FieldListLeft>
<x:FieldListBottom>654</
x:FieldListBottom>
<x:FieldListRight>785</
x:FieldListRight>
<x:CacheDetails/>

<x:ConnectionString>Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=True;Data Source=angelo;Initial Catalog=Sales2007;Client
Cache Size=25;Auto Synch Period=10000</x:ConnectionString>

<x:DataMember>Sales2007</x:DataMember>
<x:Name>Πωλήσεις vs
Budget</x:Name>
<x:pivotField>
<x:Name>Store</
x:Name>
<x:SourceName>[Store].[Store]</
x:SourceName>
<x:Orientation>Page</
x:Orientation>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x:pivotField>

<x:pivotField>
<x:Name>Εβδομάδα</x:Name>

<x:SourceName>[Εβδομάδα].[Εβδομάδα]</x:SourceName>

<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x:pivotField>

<x:pivotField>
<x:Name>ΗμέÏα</x:Name>

<x:SourceName>[ΗμέÏα].[ΗμέÏα]</x:SourceName>

<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x:pivotField>

<x:pivotField>
<x:Name>ΗμεÏομηνία</x:Name>

<x:SourceName>[ΗμεÏομηνία].[ΗμεÏομηνία]</x:SourceName>

<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>

</x:pivotField>
<x:pivotField>
<x:Name>Μήνας</
x:Name>
<x:SourceName>[Μήνας].[Μήνας]</
x:SourceName>
<x:FilterCaption>Μήνας</
x:FilterCaption>
<x:Orientation>Row</
x:Orientation>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x:pivotField>

<x:pivotField>
<x:Name>Εβδομάδα</x:Name>

<x:SourceName>[Μήνας].[Εβδομάδα]</x:SourceName>

<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x:pivotField>

<x:pivotField>
<x:Name>ΠαÏαστατικά</x:Name>

<x:SourceName>[ΠαÏαστατικά].[ΠαÏαστατικά]</x:SourceName>

<x:Orientation>Page</x:Orientation>
<x:position>2</
x:position>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
<x:AllIncludeExclude>Include</
x:AllIncludeExclude>
<x:ExcludedMember>

<x:Name>ΔΗΜΟΙ</x:Name>
<x:UniqueName>[ΠαÏαστατικά].[All
Way].[ΔΗΜΟΙ]</x:UniqueName>
</x:ExcludedMember>

</x:pivotField>
<x:pivotField>
<x:Name>Act
2007</x:Name>
<x:SourceName>[Measures].[Measure 2007]</
x:SourceName>
<x:SourceHierarchy>[Measures].[Measure
2007]</x:SourceHierarchy>
</x:pivotField>

<x:pivotField>
<x:Name>%Σ2007</x:Name>

<x:SourceName>[Measures].[%Σ2007]</x:SourceName>

<x:SourceHierarchy>[Measures].[%Σ2007]</x:SourceHierarchy>

</x:pivotField>
<x:pivotField>
<x:Name>%2006</
x:Name>
<x:SourceName>[Measures].[%2006]</
x:SourceName>
<x:SourceHierarchy>[Measures].[%2006]</
x:SourceHierarchy>
</x:pivotField>

<x:pivotField>
<x:Name>Σ2007</x:Name>

<x:SourceName>[Measures].[Σ2007]</x:SourceName>

<x:SourceHierarchy>[Measures].[Σ2007]</x:SourceHierarchy>
</
x:pivotField>
<x:pivotField>
<x:Name>Act 2006</
x:Name>
<x:SourceName>[Measures].[Measure 2006]</
x:SourceName>
<x:SourceHierarchy>[Measures].[Measure
2006]</x:SourceHierarchy>
</x:pivotField>

<x:pivotField>
<x:Name>Data</x:Name>

<x:Orientation>Column</x:Orientation>
<x:position>-1</
x:position>
<x:DataField/>
</
x:pivotField>
<x:pivotField>
<x:Name>%2006</
x:Name>
<x:TotalNumber>0</x:TotalNumber>

<x:Orientation>Data</x:Orientation>
<x:position>3</
x:position>
<x:parentField>[Measures].[%2006]</
x:parentField>
<x:NumberFormat>Percent</
x:NumberFormat>
</x:pivotField>

<x:pivotField>
<x:Name>%Σ2007</x:Name>

<x:TotalNumber>1</x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x:position>2</x:position>

<x:parentField>[Measures].[%Σ2007]</x:parentField>

<x:NumberFormat>Percent</x:NumberFormat>
</
x:pivotField>
<x:pivotField>
<x:Name>Act 2006</
x:Name>
<x:pLName>Measure 2006</x:pLName>

<x:TotalNumber>2</x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x:position>5</x:position>

<x:parentField>[Measures].[Measure 2006]</x:parentField>

<x:NumberFormat>#,##0.00 [$€-408];[red]-#,##0.00 [$€-408]</
x:NumberFormat>
</x:pivotField>

<x:pivotField>
<x:Name>Act 2007</x:Name>

<x:pLName>Measure 2007</x:pLName>
<x:TotalNumber>3</
x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x:position>1</x:position>

<x:parentField>[Measures].[Measure 2007]</x:parentField>

<x:NumberFormat>#,##0.00 [$€-408];[red]-#,##0.00 [$€-408]</
x:NumberFormat>
</x:pivotField>

<x:pivotField>
<x:Name>Σ2007</x:Name>

<x:TotalNumber>4</x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x:position>4</x:position>

<x:parentField>[Measures].[Σ2007]</x:parentField>

<x:NumberFormat>#,##0.00 [$€-408];[red]-#,##0.00 [$€-408]</
x:NumberFormat>
</x:pivotField>

<x:pivotData>
<x:Top>0.0</x:Top>

<x:TopOffset>0</x:TopOffset>
<x:Left>0</
x:Left>
<x:LeftOffset>0</x:LeftOffset>
</
x:pivotData>
<x:pivotView>
<x:TotalFormat
Style='font-family:Arial;font-size:10pt;background:mintcream'/
<x:Label>
<x:Caption>Πωλήσεις vs Budget</
x:Caption>
</x:Label>
<x:AllowEdits>false</
x:AllowEdits>
<x:AllowAdditions>false</
x:AllowAdditions>
<x:AllowDeletions>false</
x:AllowDeletions>
</x:pivotView>
</
x:pivotTable>
</xml>"></OBJECT></P>
<P>&nbsp;</P></BODY></HTML>
 
M

MomentumDev

Thanks Angelo.

I tried your HTML in a WinXP IE7 machine. But the code somehow did no
work.
Why do you have----- Î*ωλήσεις ----- these kind of Names i
the HTML file. Does this work on WinXP IE7 machine?? And if it does
then what should I expect to see??

Regards,
MomentumDe
 
P

Peter Meinl

The appended page using a SpreadSheet renders fine under Vista in IE7.
At first it did not work, because I used the wrong CLSID. Searching the
registry for OWC I found the working one.

--
Peter Meinl
ISTEC GmbH

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb"
Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<object id=SpreadSheet1
classid=CLSID:0002E559-0000-0000-C000-000000000046
style="width:49%;height:350"></object>

<div>

</div>
</form>
</body>
</html>


#
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top