HTTP OWC11 AS2005 in Win2003. Connection problem.
- From: ykfirst@xxxxxxxxx
- Date: 24 Sep 2006 21:21:53 -0700
I am trying to get an OWC11 pivot table ActiveX component to work over
the internet with AS2005. I have read so many articles, and I have
moved forward, but there doesn't seem to be any final answer.
Here is the set up. 1 Server that is running IIS6, WIN2003,
SQL2005/SP1. I set up the connection string as
PivotTable1.ConnectionString = Provider=MSOLAP.3;Data Source=http://<ip
to server>/olap/msdmpump.dll;Initial Catalog=<olapDatabaseName>
PivotTable1.DataMember = "<CUBE NAME>"
I set up the HTTP pump described in this article:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
I set up an IUSR role for the cube to be read.
I set up SQL and AS for remote access over TCP/IP.
I even set the AS2005 for anonymous access. I wll turn this back after
the test.
Everything works fine at the intranet level, but as soon as I'm outside
the domain.. boom, it won't connect.. I ran the SQL profiler, and
gotten the cryptic XML parsingg error for IUSR log-in. At any rate,
I'm all out of ideas and tricks.
I saw similar lines of discussion, but never a successful conclusion as
of yet. Any suggestions would be much appreciated.
-Young K
<html xmlns="http://www.w3.org/1999/xhtml" >
<head
<title>Test</title>
</head>
<body>
<object classid="clsid:0002E55a-0000-0000-C000-000000000046"
id="PivotTable1">
<param name="XMLData" value="<xml
xmlns:x="urn:schemas-microsoft-com:office:excel">
<x:PivotTable>
<x:OWCVersion>11.0.0.5531 </x:OWCVersion>
<x:DisplayScreenTips/>
<x:CubeProvider>msolap</x:CubeProvider>
<x:CacheDetails/>
<x:PivotView>
<x:IsNotFiltered/>
</x:PivotView>
</x:PivotTable>
</xml>">
<table width='100%' cellpadding='0' cellspacing='0' border='0'
height='8'><tr><td bgColor='#336699' height='25' width='10%'> </td><td
bgColor='#666666'width='85%'><font face='Tahoma' color='white'
size='4'><b>
Missing: Microsoft Office Web Components</b></font></td></tr><tr><td
bgColor='#cccccc' width='15'> </td><td bgColor='#cccccc'
width='500px'><br>
<font face='Tahoma' size='2'>This page requires the Microsoft Office
Web
Components.<p align='center'> <a
href='http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252c-402e-4f72-97a5
-e0fd290d4b76&DisplayLang=en'>Click
here to install Microsoft Office Web
Components.</a>.</p></font><p><font
face='Tahoma' size='2'>This page also requires Microsoft Internet
Explorer
5.01 or higher.</p><p align='center'><a
href='http://www.microsoft.com/windows/ie/default.htm'> Click here to
install
the latest Internet Explorer</a>.</font><br> </td></tr></table>
</object>
<br>
<br>
<input type="button" id="button1" value="click here">
<script language="vbscript">
sub button1_onclick()
PivotTable1.ConnectionString = Provider=MSOLAP.3;Data
Source=http://<ip to server>/olap/msdmpump.dll;Initial
Catalog=<olapDatabaseName>
PivotTable1.DataMember = "<CUBE NAME>"
Dim oPivot
Set oPivot = PivotTable1.Object
'Set the timeout to 10 secondsr
oPivot.Connection.CommandTimeout = 10
end sub
</script>
</body>
</html>
.
- Follow-Ups:
- Prev by Date: RE: AS 2005 - Dimensions and Measures
- Next by Date: Creating a local cube from a SQL Table - Chris Webb Please help
- Previous by thread: RE: AS 2005 - Dimensions and Measures
- Next by thread: Re: HTTP OWC11 AS2005 in Win2003. Connection problem.
- Index(es):