Connection Leak

Hi,
I have troubles with a threaded application on W2003 server. It
seems to leave open connections behind time to time, it sums to hundreds over
a day (the application make thousands). It is using the SQLOLEDB provider,
MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790).
I put two Trace (print) statements : (1) Connection is opened. 2)
Connection is Closed.) I can see the two statements without any Exception.
But the problem is when I see on the Performance viewer (perfmon.exe/ perfmon.
msc->Sqlserver:General Statistics, User Connections) it shows Number of users
connected to the system is like thousands and more day by day ,Means the
number of open connections are in Hundreds…thousands and more . I am also
loosing the connections immediately with out any exception.
But still I am seeing open connection.
Please can anybody sort out my problem,
Is there a known bug like this? Is there a way to trace the SQLOLEDB provider?
Regards,
Rasheeds
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200612/1
"malkeshsheth via droptable.com" <u13567@.uwe> wrote in message
news:6b18cb6b1bfe5@.uwe...
> Hi,
> I have troubles with a threaded application on W2003 server. It
> seems to leave open connections behind time to time, it sums to hundreds
> over
> a day (the application make thousands). It is using the SQLOLEDB provider,
> MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790).
> I put two Trace (print) statements : (1) Connection is opened.
> 2)
> Connection is Closed.) I can see the two statements without any Exception.
> But the problem is when I see on the Performance viewer (perfmon.exe/
> perfmon.
> msc->Sqlserver:General Statistics, User Connections) it shows Number of
> users
> connected to the system is like thousands and more day by day ,Means the
> number of open connections are in Hundreds…thousands and more . I am also
> loosing the connections immediately with out any exception.
> But still I am seeing open connection.
> Please can anybody sort out my problem,
> Is there a known bug like this? Is there a way to trace the SQLOLEDB
> provider?
>
Sounds like OleDb Session Pooling.
|||"malkeshsheth via droptable.com" <u13567@.uwe> wrote in message
news:6b18cb6b1bfe5@.uwe...
> Hi,
> I have troubles with a threaded application on W2003 server. It
> seems to leave open connections behind time to time, it sums to hundreds
> over
> a day (the application make thousands). It is using the SQLOLEDB provider,
> MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790).
> I put two Trace (print) statements : (1) Connection is opened.
> 2)
> Connection is Closed.) I can see the two statements without any Exception.
> But the problem is when I see on the Performance viewer (perfmon.exe/
> perfmon.
> msc->Sqlserver:General Statistics, User Connections) it shows Number of
> users
> connected to the system is like thousands and more day by day ,Means the
> number of open connections are in Hundreds…thousands and more . I am also
> loosing the connections immediately with out any exception.
> But still I am seeing open connection.
> Please can anybody sort out my problem,
> Is there a known bug like this? Is there a way to trace the SQLOLEDB
> provider?
>
OOPS.
Sounds like you're using Connection Pooling (or whatever they call it in
OleDb)
See, eg
Support WebCast: ODBC Connection Pooling and OLEDB Session Pooling in
Microsoft Data Access Components
http://support.microsoft.com/kb/324686
David