[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Connections not being released with ODBC.Net and DB/2

Edward J. Stembler

3/18/2002 9:32:00 PM

Is anyone out there using IBM's DB/2 for Windows and
Microsoft's ODBC.Net? We're having a problem where the
connections are never being released, regarless of
explicitly doing so in code. Anyone else experiencing
this? Anyone heard of any work arounds?
3 Answers

(David Sceppa)

3/18/2002 10:46:00 PM

0

George

3/19/2002 3:35:00 AM

0

Yup, had the same problem. It seems that if your
connection object is an instance variable of an object,
the connection is never released properly. This can be
clearly seen in the ODBC Connection Pooling counters in
perfmon.

If, however, you create the connection as a local variable
in a method, it works fine.

-G


>-----Original Message-----
>Is anyone out there using IBM's DB/2 for Windows and
>Microsoft's ODBC.Net? We're having a problem where the
>connections are never being released, regarless of
>explicitly doing so in code. Anyone else experiencing
>this? Anyone heard of any work arounds?
>.
>

Edward J. Stembler

3/20/2002 3:32:00 PM

0

Actually, we were using public shared Connection(s).
After chaning them to use local method variables, it
worked great. Thanks!!


>-----Original Message-----
>Yup, had the same problem. It seems that if your
>connection object is an instance variable of an object,
>the connection is never released properly. This can be
>clearly seen in the ODBC Connection Pooling counters in
>perfmon.
>
>If, however, you create the connection as a local
variable
>in a method, it works fine.