Re: crystal reports unreleased connections
From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 10/25/04
- Next message: Aaron: "Re: ANY COM Interop GURUS out there!? - Nested Structs with arrays"
- Previous message: Jay B. Harlow [MVP - Outlook]: "Re: Getting an error in visualbasic.dll"
- In reply to: Peter Proost: "Re: crystal reports unreleased connections"
- Next in thread: Bernie Yaeger: "Re: crystal reports unreleased connections"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 11:15:21 -0400
Hi Peter,
Your ISP is blocking you from perceived spam; happens to me all the time.
Just check back here periodically.
You're correct; I am working on the problem now to see if I can find a fix;
I will get back to you asap.
Bernie
"Peter Proost" <pproost@nospam.hotmail.com> wrote in message
news:ud$i$zouEHA.2520@TK2MSFTNGP15.phx.gbl...
> 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: Aaron: "Re: ANY COM Interop GURUS out there!? - Nested Structs with arrays"
- Previous message: Jay B. Harlow [MVP - Outlook]: "Re: Getting an error in visualbasic.dll"
- In reply to: Peter Proost: "Re: crystal reports unreleased connections"
- Next in thread: Bernie Yaeger: "Re: crystal reports unreleased connections"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
