Hello Can somone please tell me how to connect to a pivot table through asp code? We are using an oracle database.

Some of our code looks like this:
PivotTable.DisplayAlerts = False
Set c = PivotTable.Constants
PivotTable.ConnectionString = sConn.ConnectionString
PivotTable.ActiveView.AutoLayout

set pview = PivotTable.ActiveView
pview.FieldSets("test1").Fields(0).Caption= "product no"
view.FieldSets("test2").Fields(0).Caption= "line code"

In our body tag we have the following:
<object id="PivotTable" codebase="" classid="CLSID:0002E520-0000-0000-C000-000000000046" width="518" height="384">

sconn is equal to the dsn name, user id, and password.

When we execute the page, we get an outline of a pivot table but then it says no data source specified.

Any help is appreciated!!!!!

Hi Irene
Did you solve the problem? I not getting any further than you... but will like to hear if you found the solution.

Cheers Datras

Hi Datras
Yes I did figure out what the problem was. In my connection string I was not including a provider.

PivotTable1.ConnectionString = "Provider=MSDAORA.1;User ID=test;Data Source=dbname;Password=test"


I think depending on what database you are connecting to depends what the provider is.