OWC 11 with VS2005 - Client side not working in web or intranet

A

Angelo

Using Pivot 11 with asp.net 2 working VS2005 has no problem in my
pc(local) but if i run this from an external pc in the network or WEB
he can't see Data provider.
Can anyone help on this ?

My aspx goes like this


<%@ page Language="VB" %>

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

<script runat="server">

</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Sprider Sales Vs Budget</title>
</head>
<body>
<OBJECT ID="PTable" CLASSID="CLSID:0002E55a-0000-0000-
C000-000000000046"
WIDTH="100%" HEIGHT="60%">
</OBJECT>
<P/>

<script language=vbscript>

Dim c ,t 'For PivotTable constants.
Dim oView
Dim sResults
Dim aStates

Function Window_OnLoad()
Set c = PTable.Constants
'Connect to the data source.
PTable.UseRemoteProvider = true
PTable.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=E:\My Access\test.mdb; Persist Security Info=False"
PTable.DataMember = "MonthSales"
Set oView = PTable.ActiveView
Set Chart1Title = oView.TitleBar
' Set the caoption for the title.
Chart1Title.Caption = "Sales Vs Budget"
'Add Dimensions to the column, row, and filter axes.
oView.ColumnAxis.InsertFieldSet oView.FieldSets("Yr")
oView.FieldSets("Yr").Fields(0).Caption = "Year"
oView.ColumnAxis.DisplayEmptyMembers = True
oView.ColumnAxis.FieldSets("Yr").Fields(0).Subtotals(1) = false
oView.RowAxis.InsertFieldSet oView.FieldSets("Store")
oView.RowAxis.DisplayEmptyMembers = true
oView.FilterAxis.InsertFieldSet oView.FieldSets("Mont")
oView.FilterAxis.Fieldsets("Mont").Caption="Month"
oView.DataAxis.InsertFieldSet oView.FieldSets("Sales")
' aStates = Array("Cleared", "Checked", "Gray")
oView.DataAxis.InsertTotal oView.AddTotal("Sum of Sales",
oView.FieldSets("Sales").Fields(0),1)
oView.Totals("Sum of Sales").NumberFormat= "$#,##0"
oView.FieldLabelBackColor = "Lavender"
oView.TotalBackColor = "White"
oView.HeaderBackColor = "Gold"
ptable.ActiveData.HideDetails()
End Function
</SCRIPT>
</body>
</html>
 
L

Lautlos

Hello Angelo,

hmm, you specify a absolute path:
E:\My Access\test.mdb

This file has to exist on the computer, where you open the Webpage.

Also make sure, that the correct MDAC (DataAccessComponents) and PTS
(PivotTableServices) are installed on the client (I am not sure where the ole
db data privider is included).

Clear skies,
Lautlos
 
L

Lautlos

You could provide the data in many other ways, for example as XML-Data, a
Table in a SQL-Server Database or a Cube in an Analysis Server. Or you could
try to put the file on your webserver, but I am not sure this works... If it
is an intranet environment, you could provide the data on a shared directory.

Just look in your dokumentation, examples or buy one of the many mentioned
books in this newsgroup. ;-)

If you have much data with many dimensions and want to distribute the date
in an intranet, I would recommend installing an Analysis Server.
 
A

Angelo

I try all this and i will tell you more

Thanks Thomas
ps : If "they" - M$ - stops the OWC i'm sure they will discover
another tip ;-)

Ï/Ç Lautlos Ýãñáøå:
 
A

Angelo

Finally works with analysis Services ,also with OWC 10.0
Thanks Thomas

Ο/Η Angelo έγÏαψε:
 

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

Similar Threads

owc11 connectionstring error with olap - help 1
OWC Pivottable w/ webservice asp.net 3
OWC ChartSpace.PrintQuality3D not working 1

Top