P
Peter Proost
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
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