水晶报告未发布的连接 [英] crystal reports unreleased connections

问题描述

小组，


我有一个有趣的问题，我不知道这是不是正确的小组但是

我想因为到目前为止我读过的所有内容都说它是.net

问题。这就是问题所在，我们正在使用水晶报告9和vb.net以及

我们正在使用crystalrepotViewer来显示我们的报告。但是每次我们打开一个报告时都会打开一个报告，或者sql server的连接仍然存在，所以如果我用报表查看器打开5个表单

我有5个睡眠连接我的SQL服务器。如果

我关闭了所有5个表单，我仍然有5个打开的连接，并且在我关闭整个应用程序之前他们不会去

。这个问题是

一些用户只使用应用程序打印报告所以大约一个小时左右

他们有80个睡眠连接。我已经尝试在结束事件中使用

crystalreportviewer1.dispose，但这没有

效果。 crviewer也没有连接。关闭方法或其他什么

那样

任何帮助都会非常感激


Grtz 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

推荐答案

嗨彼得，


这很有趣 - 你怎么知道你有这些睡眠联系？


Bernie Yaeger


" Peter Proost" < PP ***** @ nospam.hotmail.com>在消息中写道

news：％2 **************** @ TK2MSFTNGP14.phx.gbl ...

Hi Peter,

This is interesting - how do you know you have these sleeping connections?

Bernie Yaeger

"Peter Proost" <pp*****@nospam.hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

Hi Group ，

我有一个有趣的问题，我不知道这是不是正确的团队
但我想是的，因为我读到的一切都是关于它到目前为止说这是一个.net
问题。这就是问题所在，我们正在使用水晶报告9和vb.net以及
我们正在使用crystalrepotViewer来显示我们的报告。但每次我们打开一个报告时，与sql server的连接仍然存在，所以如果我用报表查看器打开5
表单，我的sql server中有5个睡眠连接。
如果
我关闭了所有5个表单，我仍然有5个打开的连接，并且在关闭整个应用程序之前它们不会离开。这个问题是，有些用户只使用应用程序打印报告，所以大约一个小时左右后，他们已经有80个睡眠连接。我已经尝试将
crystalreportviewer1.dispose放在表单结束事件中，但这没有
效果。 crviewer也没有联系。关闭方法或
这样的东西
任何帮助都将非常感谢

Grtz 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

嗨伯尼，


抱歉，我之前没有回复你的帖子，但它没有'''在我的

新闻阅读器中显示它仍然不是我在谷歌上看到它。我知道我已经有了

睡眠连接因为它们出现在sql server enterprise

manager


greetz Peter


" Peter Proost" < PP ***** @ nospam.hotmail.com>在消息中写道

news：#i ************** @ TK2MSFTNGP14.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" <pp*****@nospam.hotmail.com> wrote in message
news:#i**************@TK2MSFTNGP14.phx.gbl...

Hi Group，

我有一个有趣的问题，我不知道这是不是正确的团体
但是我想是因为我到目前为止读到的所有内容都说它' 'sa .net
问题。这就是问题所在，我们正在使用水晶报告9和vb.net以及
我们正在使用crystalrepotViewer来显示我们的报告。但每次我们打开一个报告时，与sql server的连接仍然存在，所以如果我用报表查看器打开5
表单，我的sql server中有5个睡眠连接。
如果我关闭所有5个表单，我仍然有5个打开的连接，并且在关闭整个应用程序之前它们不会离开。这个问题是，有些用户只使用应用程序打印报告，所以大约一个小时左右后，他们已经有80个睡眠连接。我已经尝试将
crystalreportviewer1.dispose放在表单结束事件中，但这没有
效果。 crviewer也没有连接。关闭方法或
之类的东西
任何帮助都会非常感激

Grtz 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

嗨Peter，


您的ISP阻止您感知垃圾邮件;偶然发生在我身上。

请定期回来查看。


你是对的;我现在正在研究这个问题，看看能否找到解决办法;

我会尽快回复你。


伯尼


" Peter Proost" < PP ***** @ nospam.hotmail.com>在消息中写道

news：ud ************** @ TK2MSFTNGP15.phx.gbl ...

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" <pp*****@nospam.hotmail.com> wrote in message
news:ud**************@TK2MSFTNGP15.phx.gbl...

嗨Bernie，新闻阅读器中，它仍然不是我在谷歌上看到的。我知道我已经有了
睡眠连接，因为它们出现在sql server enterprise


greetz Peter

Peter Proost < PP ***** @ nospam.hotmail.com>在消息中写道
新闻：#i ************** @ TK2MSFTNGP14.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" <pp*****@nospam.hotmail.com> wrote in message
news:#i**************@TK2MSFTNGP14.phx.gbl...

Hi Group，
<我有一个有趣的问题，我不知道这是不是正确的组

Hi Group,

I''ve got an interesting problem, I don''t know if this is the right group

但是

我想是的，因为我有一切到目前为止，读到这个问题说它是一个.net
问题。这就是问题所在，我们正在使用水晶报告9和vb.net以及
我们正在使用crystalrepotViewer来显示我们的报告。但每次我们打开一个报告时，与sql server的连接仍然存在，所以如果我用报表查看器打开5

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

表单

我有在我的sql server中有5个睡眠连接。

with the report viewer I''ve got 5 sleeping connections in my sql server.

如果

我关闭了所有5个表单，我仍然有5个打开的连接，并且在我关闭之前他们不会去
整个申请。这个问题是，有些用户只使用应用程序打印报告，所以大约一个小时左右后，他们已经有80个睡眠连接。我已经尝试将
crystalreportviewer1.dispose放在表单结束事件中，但这没有
效果。 crviewer也没有连接。关闭方法或

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

这样的东西
任何帮助都会非常感激

Grtz Peter

like that
Any help would be very much appreciated

Grtz Peter

这篇关于水晶报告未发布的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！