PivotTable Control and ConnectionString property

[Haq Yunus]

Hi,

Here is a code snippet for adding a PivotTable MS Office control in a (ASP)webpage:

-------------------------------------------
Function Window_OnLoad()

Set c = PTable.Constants

'Connect to the data source.
PTable.ConnectionString = _
"provider=msolap;data source=YourServer;inital catalog=Foodmart 2000;"
PTable.DataMember = "Sales"

Set oView = PTable.ActiveView

'Add Dimensions to the column, row, and filter axes.
oView.ColumnAxis.InsertFieldSet oView.FieldSets("Time")
oView.ColumnAxis.DisplayEmptyMembers = True
oView.RowAxis.InsertFieldSet oView.FieldSets("Store")
oView.RowAxis.DisplayEmptyMembers = True
oView.FilterAxis.InsertFieldSet oView.FieldSets("Product")

'Add a total to the data area.
oView.DataAxis.InsertTotal oView.Totals("Store Sales")
oView.Totals("Store Sales").NumberFormat = "_($* #,##0_)"

aStates = Array("Cleared", "Checked", "Gray")

End Function
-------------------------------------------

I want to hide the ConnectionString value from my webpage. Is there any way to do that? Or else the user of the application can click 'View Source' in the browser and read the credentials. I know PivotTable MS Office control is a client-side Active-X component and it is also intialized on client-side. But is there a solution? A workaround?. Any help will be greatly appreciated.

Thanks.
Haq

 

[Haq]

Dan,

First of all thanks for replying.

Well, OK. But here is a link to a website who have implemented the same thing and the connection string is hidden. Any idea how it is done?

http://www.utcodes.org/queryabledata/cube/analyzer/default.asp
Select Adhoc report .

Haq.