how to deal with these CR sessions?

njleo
njleo used Ask the Experts™
on
  I am using asp+CR8. When I build a CR Application and connect it with Oracle in a asp file (using
session("oApp").LogOnServer), I find a inactive seeion appears in Oracle. But the trouble is every time I refresh the file ,it makes one more new inactive session( made by dllhost.exe) in the Oracle database. And I can not kill the session by simplily use "session("oApp").LogOffServer".
   Please advise..
   Thank you!
     
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dejavu!

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_20403124.html

I thought that maybe the last person who asked this could help - but hey, that was you.

I gather by the response to your question last time that there aren't many Oracle experts among us.

Due to the response last time, I'm surprised that you haven't recognised this as as a difficult issue and awarded at least 200 points to your question.  Its amazing what extra effort people will go to for your question if the reward is higher than usual.

I have used Crystal and Oracle in a VB environment and have not had this trouble - but unfortunately a have no code with me even on this.

Do any of these help at all:
http://support.crystaldecisions.com/library/kbase/articles/c2009548.asp

http://support.crystaldecisions.com/library/kbase/articles/c2009964.asp

http://support.crystaldecisions.com/library/kbase/articles/c2010102.asp

http://support.crystaldecisions.com/library/kbase/articles/c2012194.asp


Author

Commented:
 I found these connections are made by PageEngine, it could be released after the default time. Is it possible to reuse the connection instead of make a new connection?
By the way, I am a green hand here.And I have already give
all my points :(
  Thanks!
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

If the articles and examples cannot help you, then I'm afraid I can help you no more.

I am not familiar with asp.

Author

Commented:
 Thanks gawilson2000 . I have already settled the problem by setting session.timeout . It is not the best way, but it did help me a lot. Thank you for your help.
That's fine, thanks for the points - I didn't think I helped that much.

Hi,

I got similar problem with CR 9 .....

I am using asp+CR9. When I run an CR report and connect it with Oracle in a asp file, I find a inactive session appears in Oracle. The session remains eventhough the asp is closed ! How can I remove those inactive session?

   Please advise..
   Thank you!
Look into the 'session.timeout' option or do the articles I have referenced help?  

If not, it may be an Oracle setting.  If you can determine the problem to be an Oracle issue then I recommend that you raise a question in the Oracle section.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial