Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    16

    Question Unanswered: how to connect to pivot table using oracle?

    Hello Can somone please tell me how to connect to a pivot table that is going against an oracle db.


    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!!!!!

  2. #2
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    PivotTable is Microsoft Web Office component.I think it only supports Access or SQL Server OLAP Service.

  3. #3
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    Sorry.What I say above is not right.

    I did it.You can create a pivotTable to oracle.I think your mistake is at odbc setting or connect string format.

    eg, my codes:

    PivotTable1.DisplayAlerts = True
    PivotTable1.AutoFit = True
    PivotTable1.DisplayExpandIndicator = True
    PivotTable1.ConnectionString = "dsn=oracle817;uid=scott;pwd=tiger"
    PivotTable1.CommandText = "select customer,product,sum(amount) from scott.sales " & _
    "group by customer,product"

    oracle817 is my oracle odbc dsn name.

  4. #4
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    And you haven't any query(select * from ...).So no data the pivottable control can process.

  5. #5
    Join Date
    Sep 2003
    Posts
    16
    Sorry I did have a sql just didn't include it..

    before the body tag, I have
    PivotTable1.DisplayAlerts = True
    PivotTable1.AutoFit = True
    PivotTable1.DisplayExpandIndicator = True
    PivotTable1.ConnectionString = "dsn=WBS;uid=plus;pwd=help"
    PivotTable1.CommandText = "select date, sub, Salesorg, qty from dbtable where Quantity= '12'"

    then in the body i have the following tag..
    <object id="PivotTable1" codebase=""
    classid="CLSID:0002E520-0000-0000-C000-000000000046" width="518" height="384">

    when i execute my page, I get the error "variable is undefined 'PivotTable1'"

    I already defined the pivot table in my object tag. Any ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •