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


 

Forums >

microsoft.public.dotnet.framework.odbcnet

ODBCConnection.close not releasing resources

George

3/25/2005 6:30:00 PM

Hi all,

I'm using ODBCConnection to paradox database. It works fine but when I open and close connection repeatedly, I found that amount of memory and number of handles is growing and resources used by odbcconnection are not released.

I'm using the following construction:

Dim objConn As New OdbcConnection

objConn.ConnectionString = ConnectionStringZoner

objConn.Open()

objConn.Close()

objConn.Dispose()

OdbcConnection.ReleaseObjectPool()

GC.Collect()


I have also tried objConn = nothing but nothing has helped.
Can anybody help me, please?

Thanks for any tip

Regards

George
2 Answers

Mark Escandon

5/18/2005 6:00:00 PM

0

I''m having the exact same problem.
I''ve gone through my code repeatedly and can''t find what''s causing it.
Please share any solutions you may have found and I''ll do the same.
--
Mark Escandon
Production/Systems Manager
Fybon Industries


"George" wrote:

> Hi all,
>
> I''m using ODBCConnection to paradox database. It works fine but when I open and close connection repeatedly, I found that amount of memory and number of handles is growing and resources used by odbcconnection are not released.
>
> I''m using the following construction:
>
> Dim objConn As New OdbcConnection
>
> objConn.ConnectionString = ConnectionStringZoner
>
> objConn.Open()
>
> objConn.Close()
>
> objConn.Dispose()
>
> OdbcConnection.ReleaseObjectPool()
>
> GC.Collect()
>
>
> I have also tried objConn = nothing but nothing has helped.
> Can anybody help me, please?
>
> Thanks for any tip
>
> Regards
>
> George
>
>

Mark Escandon

5/19/2005 4:25:00 PM

0

I think its actually related to the odbc driver.
I switched from the microsoft paradox driver to an old intersolv paradox
driver and the number of handles that increased were considerably less.



--
Mark Escandon
Production/Systems Manager
Fybon Industries


"George" wrote:

> Hi all,
>
> I''m using ODBCConnection to paradox database. It works fine but when I open and close connection repeatedly, I found that amount of memory and number of handles is growing and resources used by odbcconnection are not released.
>
> I''m using the following construction:
>
> Dim objConn As New OdbcConnection
>
> objConn.ConnectionString = ConnectionStringZoner
>
> objConn.Open()
>
> objConn.Close()
>
> objConn.Dispose()
>
> OdbcConnection.ReleaseObjectPool()
>
> GC.Collect()
>
>
> I have also tried objConn = nothing but nothing has helped.
> Can anybody help me, please?
>
> Thanks for any tip
>
> Regards
>
> George
>
>