Re: crystal reports unreleased connections
From: Peter Proost (pproost_at_nospam.hotmail.com)
Date: 10/25/04
- Next message: DC: "Re: Values can't be grabbed?"
- Previous message: Herfried K. Wagner [MVP]: "Re: Form Resize question"
- In reply to: Peter Proost: "crystal reports unreleased connections"
- Next in thread: Bernie Yaeger: "Re: crystal reports unreleased connections"
- Reply: Bernie Yaeger: "Re: crystal reports unreleased connections"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 14:17:42 +0200
Hi Bernie,
sorry I haven't replied earlier to your post but it didn't show up in my
news reader and it still doesn't but I saw it on google. I know I've got the
sleeping connections because they show up in the sql server enterprise
manager
greetz Peter
"Peter Proost" <pproost@nospam.hotmail.com> wrote in message
news:#izb0kAuEHA.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: DC: "Re: Values can't be grabbed?"
- Previous message: Herfried K. Wagner [MVP]: "Re: Form Resize question"
- In reply to: Peter Proost: "crystal reports unreleased connections"
- Next in thread: Bernie Yaeger: "Re: crystal reports unreleased connections"
- Reply: Bernie Yaeger: "Re: crystal reports unreleased connections"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|