Re: crystal reports unreleased connections
From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 10/22/04
- Next message: ZorpiedoMan: "Control Keys List"
- Previous message: Jim: "Looking for ideas as to how I could do this....."
- In reply to: Peter Proost: "crystal reports unreleased connections"
- Next in thread: Peter Proost: "Re: crystal reports unreleased connections"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 22 Oct 2004 12:49:04 -0400
Hi Peter,
This is interesting - how do you know you have these sleeping connections?
Bernie Yaeger
"Peter Proost" <pproost@nospam.hotmail.com> wrote in message
news:%23izb0kAuEHA.2000@TK2MSFTNGP14.phx.gbl...
> 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
>
>
- Next message: ZorpiedoMan: "Control Keys List"
- Previous message: Jim: "Looking for ideas as to how I could do this....."
- In reply to: Peter Proost: "crystal reports unreleased connections"
- Next in thread: Peter Proost: "Re: crystal reports unreleased connections"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
