crystal reports unreleased connections

From: Peter Proost (pproost_at_nospam.hotmail.com)
Date: 10/27/04


Date: Wed, 27 Oct 2004 10:49:11 +0200

Hi Group,

I already posted this question to the microsoft.public.dotnet.languages.vb
group with the same subject, and Bernie Yaeger and me already talked about
it, but we can't find a solution, and he suggested me to post it here, so I
hope anyone here can help, you can read our thread in the
microsoft.public.dotnet.languages.vb to see what we've already tested. Below
is my original post

Thnx in advance and greetz Peter

Hi Group,

I've got an interesting problem, I don't know if this is the right group but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotViewer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5 forms
with the report viewer I've got 5 sleeping connections in my sql server. If
I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportviewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.close method or something
like that
Any help would be very much appreciated

Grtz Peter



Relevant Pages

  • Re: crystal reports unreleased connections
    ... > sleeping connections because they show up in the sql server enterprise ... we're using crystal reports 9 and vb.net and ... >> we're using the crystalrepotViewer to show our reports. ... >> with the report viewer I've got 5 sleeping connections in my sql server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: crystal reports unreleased connections
    ... we're using crystal reports 9 and vb.net and ... > we're using the crystalrepotViewer to show our reports. ... > open a report the connection to or sql server remains, ... > with the report viewer I've got 5 sleeping connections in my sql server. ...
    (microsoft.public.dotnet.languages.vb)
  • crystal reports unreleased connections
    ... we're using crystal reports 9 and vb.net and ... we're using the crystalrepotViewer to show our reports. ... with the report viewer I've got 5 sleeping connections in my sql server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: crystal reports unreleased connections
    ... This is interesting - how do you know you have these sleeping connections? ... we're using crystal reports 9 and vb.net and ... > we're using the crystalrepotViewer to show our reports. ... > with the report viewer I've got 5 sleeping connections in my sql server. ...
    (microsoft.public.dotnet.languages.vb)
  • Running large reports off SQL server (i.e. Crystal Reports)
    ... I need to run large reports off a SQL server using an application like ... Unfortunately Crystal Reports for VS.NET runs into ... Typically how does one go about building queries that calculate data ...
    (microsoft.public.sqlserver.programming)