OWC and session

[psychatricmeuh]

hi!

please tell me if some of you had experienced issues with OWC and
user-session.
I developp for a big application which works with user-session. it
works fine, but not with the OWC. I use the owc(11) and quickly i loose
the session, however i do not do anything special on this session (just
get some data which are registered).

do you know if the OWC do something special with the session???

thanks!

 

[Alvin Bruney [MVP - ASP.NET]]

Session is not related to the OWC in anyway. You must have some other
problem. One common cause is application pool recycling. Have you eliminated
this as a factor?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[psychatricmeuh]

I didn't know what is "application pool recycling". after research I've
found... but it's for IIS6.0 and I'm under IIS5.0 . For this IIS it's
not available
(http://msdn.microsoft.com/library/d...html/d50e564b-0793-48e5-b624-b2c9b4fae087.asp)
so i don't think it's the cause of my problem!

Thanks for your help.

 

[psychatricmeuh]

I use frameset in my webpage, it 's possible the frame are reasons of
my problem.
I will try to know if it's true. But i accept all ideas about the
problem

Thanks

 

[psychatricmeuh]

After many resaerch, i've found the line which caused my problem....
I explain, i've a pivottable connect to a cube on my web page. the user
can save the result of the pivottable. He can also re-use what he
saved. and when i try to get the data FOR THE SECOND TIME in the pivot
table, i loose my user-session....
this is the line which put the data into the pivottable's XmlaData :
"parent.frames["pivottable"].document.getElementById("PivotTable1").XMLData=Data;"
Data is the string which contain the xmla.
parent.frames["pivottable"] is the frame of the document which has the
pivotable (the button to get the data is on another frame)

do you know why i loose my session?

 

[Alvin Bruney [MVP - ASP.NET]]

do you know why i loose my session?
nope, but you might try off-loading the contents of the pivot table into a
server-side control. Since a server-side automatically connects to
viewstate, your data would be reloadable after a post.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[psychatricmeuh]

i've tried all the day to acces the pivottable from codebehind but i
didn't find how to do.....
my pivottable is in a frame and i would like to access the property
"XmlData" of the pivottable but the code will be in another frame.
i've tried to implement the PivotTableClass, but i didn't find how to
make the pivottable and the pivottableclass related.

can you help me please by explain how to access my pivottable in code
behind?

thanks a lot for your answers ....

 

[Alvin Bruney [MVP - ASP.NET]]

i'd recommend you get a copy of the black book.

basically, you will need to stream script out from the server to the client
using something like
Response.Write("<script>documentall.all.pivottable1.XMLDATA='" + strXML +
"'</script>");

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[psychatricmeuh]

I've already try the "response.write..." [
Response.Write("<script>parent.frames[" & """pivottable""" &
"].document.getElementById(" & """PivotTable1""" & ").XMLData='" + xmla
+ "'</script>") ] but it does the same: I loose my session after the
second try to get data into the pivottable....
i really don't understand....
i will look at your book to try to find a solution.

thanks

 

[psychatricmeuh]

i finished to passed through my issue.
i had to reload all the frame when i put data into my pivottable, and
then i don't loose my session.

thanks for your help.