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

    Question Unanswered: connecting and creating pivot table by code

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

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    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

  3. #3
    Join Date
    Sep 2003
    Posts
    16
    Originally posted by datras
    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.

Posting Permissions

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