Error With My Request Maybe OWC...

Hi, (sorry for my english...)

I have a probelm to build my Pivot table.

Indeed,

The goal is just to see an example of Table Pivot with our Database...

For that, I use this link :

http://www.csharphelp.com/archives4/archive623.html


I try to adapt the code but some problems...

I use visual developper, and i have installed OWC11 & .NET framework 2.0.


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Office.Interop.Owc11;

public partial class _Default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
//determine whether or not the browser supports OWC
if(Request.Browser.ActiveXControls)
{
Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");
//cause the object to load data on the client
Response.Write(@"<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");
Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");

PivotTableClass PTClass = new PivotTableClass();

PTClass.ConnectionString = ConfigurationManager.ConnectionStrings["TimeTrackingDB"].ToString();
PTClass.DataMember = "";
PivotView pview = PTClass.ActiveView;
Response.Write(pview.FieldSets.Count);

}

}
}


When i'm lauching there is an error : HRESULT E_FAIL

http://fists148.free.fr/Error.JPG

If i put the last lines in commentary,



public partial class _Default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
//determine whether or not the browser supports OWC
if(Request.Browser.ActiveXControls)
{
Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");
//cause the object to load data on the client
Response.Write(@"<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");
Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");

}

}
}


The component is loading but it seems to be an issue with the connection database...

In my web.config, I Have this :

<connectionStrings>
<add name="TimeTrackingDB" connectionString="Data Source=PORT06139DEV_2000;Initial Catalog=TimeTracking;Persist Security Info=True;User ID=user_TTT;Password=user_TTT;pooling=false"/>

</connectionStrings>

Error connection (http://fists148.free.fr/OWCscreen.JPG)

If you have any idea, i take it...I'm deseperate :eek:

Thanks By advance