A
Anthony
I have an application insing the pivot table control in the office web
components. I am trying to set up web access to it. My 2 choices are
http access to the analysis server or RDS. I have the http access set
up and working, but I am having a speed issue, so I want to also set
up rds as a test.
I have a test application the works perfect using the SQLOLEDB
provider against relational data usind and RDS connect handler, but
the problem occurs when I switch to the MSOLAP provider and cube data.
If I use a normal connect string against cube data it works perfect.
When I switch the connect tring to and RDS handle, the pivot tables
errors out that it cannot find the database, and the database it is
looking for is the name of the handle.
The following code is a simple html script the configures a pivot
table, and allows fields to be added to it using the pivot table
component.
<HTML>
<BODY ONLOAD = "Setup_PT()">
<!-- OWC Data Source Component for getting at the data -->
<object id="dsc"
classid="clsid:0002E530-0000-0000-C000-000000000046"
width="1" height="1" VIEWASTEXT>
</object>
<OBJECT ID="PivotControl"
CLASSID="CLSID:0002E520-0000-0000-C000-000000000046"
style="HEIGHT: 500px; WIDTH: 500px">
</OBJECT>
<SCRIPT language=VBScript>
Sub Setup_PT()
strConn = "Provider=MSOLAP;Data source=MS_FM_Cube"
' strConn = "Provider=MSOLAP;Persist Security Info=False;Data
Source=morgana-2ks;Initial Catalog=FoodMart 2000"
dsc.ConnectionString = strConn
'Set the UseRemoteProvider property to True to make the necessary
'modifications to the connection string
dsc.UseRemoteProvider = true
' Connect the PivotTable list to the OLAP data source.
set PivotControl.DataSource = dsc.object
PivotControl.DataMember = "Sales"
End Sub
</SCRIPT>
</BODY>
</HTML>
As you can see form the code the RDS handle is "MS_FM_Cube"
The msdfmap.ini hase the following entry
[connect MS_FM_Cube]
Connect="Provider=MSOLAP;Persist Security Info=False;Data
Source=morgana-2ks;Initial Catalog=FoodMart 2000"
Access=ReadOnly
The error is from this line PivotControl.DataMember = "Sales"
and reads "Unable to connect to analysis server. The server name
'MS_FM_Cube' was not found.
This leads me to beleive that the provider is not getting the connect
string though the rds handle. RDS is set up correct for relational
data, but I am having a problem with cube data.
Does anybody have any ideas?
components. I am trying to set up web access to it. My 2 choices are
http access to the analysis server or RDS. I have the http access set
up and working, but I am having a speed issue, so I want to also set
up rds as a test.
I have a test application the works perfect using the SQLOLEDB
provider against relational data usind and RDS connect handler, but
the problem occurs when I switch to the MSOLAP provider and cube data.
If I use a normal connect string against cube data it works perfect.
When I switch the connect tring to and RDS handle, the pivot tables
errors out that it cannot find the database, and the database it is
looking for is the name of the handle.
The following code is a simple html script the configures a pivot
table, and allows fields to be added to it using the pivot table
component.
<HTML>
<BODY ONLOAD = "Setup_PT()">
<!-- OWC Data Source Component for getting at the data -->
<object id="dsc"
classid="clsid:0002E530-0000-0000-C000-000000000046"
width="1" height="1" VIEWASTEXT>
</object>
<OBJECT ID="PivotControl"
CLASSID="CLSID:0002E520-0000-0000-C000-000000000046"
style="HEIGHT: 500px; WIDTH: 500px">
</OBJECT>
<SCRIPT language=VBScript>
Sub Setup_PT()
strConn = "Provider=MSOLAP;Data source=MS_FM_Cube"
' strConn = "Provider=MSOLAP;Persist Security Info=False;Data
Source=morgana-2ks;Initial Catalog=FoodMart 2000"
dsc.ConnectionString = strConn
'Set the UseRemoteProvider property to True to make the necessary
'modifications to the connection string
dsc.UseRemoteProvider = true
' Connect the PivotTable list to the OLAP data source.
set PivotControl.DataSource = dsc.object
PivotControl.DataMember = "Sales"
End Sub
</SCRIPT>
</BODY>
</HTML>
As you can see form the code the RDS handle is "MS_FM_Cube"
The msdfmap.ini hase the following entry
[connect MS_FM_Cube]
Connect="Provider=MSOLAP;Persist Security Info=False;Data
Source=morgana-2ks;Initial Catalog=FoodMart 2000"
Access=ReadOnly
The error is from this line PivotControl.DataMember = "Sales"
and reads "Unable to connect to analysis server. The server name
'MS_FM_Cube' was not found.
This leads me to beleive that the provider is not getting the connect
string though the rds handle. RDS is set up correct for relational
data, but I am having a problem with cube data.
Does anybody have any ideas?