ODBCConnection Problem

[Mario Elmers]

Hello,

i use a ODBCConnection object in a multithread application.
Everytime the thread is running i create a new object of the ODBCConnection
and run my queries to fill my dataset. After that, i close the connection
and set it to nothing. But the application didn't free the memory of the
connection after the thread is shutdown.

Is that a genral fault of the ODBC driver?

I use Vb .NET 2003 & MaxDB 7.5 and MaxDB ODBCDriver 7.06

[Cor Ligthert [MVP]]

Re: ODBCConnection Problem

Mario,

There are in my opinion not much people anymore that uses ODBC in
combination with Net, it is the right provider or OleDB.

Secondly the newsgroups where actual this kind of more not to the language
database problems are handled is

microsoft.publi c.dotnet.framew ork.adonet.

Because that low use of ODBC have you more change on an answer in that
newsgroup.

I hope this helps,

Cor

[CT]

Re: ODBCConnection Problem

Have you tried calling the Dispose method on the connection?

--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk

"Mario Elmers" <MarioElmers@di scussions.micro soft.com> wrote in message
news:F27914D9-0F36-4954-A497-4EDB42C83C95@mi crosoft.com...[color=blue]
> Hello,
>
> i use a ODBCConnection object in a multithread application.
> Everytime the thread is running i create a new object of the
> ODBCConnection
> and run my queries to fill my dataset. After that, i close the connection
> and set it to nothing. But the application didn't free the memory of the
> connection after the thread is shutdown.
>
> Is that a genral fault of the ODBC driver?
>
> I use Vb .NET 2003 & MaxDB 7.5 and MaxDB ODBCDriver 7.06[/color]

[Mario Elmers]

Re: ODBCConnection Problem

Thank you for your help, i will post again in the adonet group