HANDLES NOT BEING RELEASED

[Mark Escandon]

I'VE POSTED THIS BEFORE BUT I STILL HAVE THE PROBLEM-

I wrote a database client with vb.net. It runs fine for about a week and
then I loose all connectivity. Windows NT displays a system error "no more
internal File identifiers".
I checked my program carefully to make sure that every odbc and streamreader
is closed after I open them; However,Using process explorer, I can see that
about 15 handles get added everytime I add a record.

I force a system.gc.collect and I still see no difference; handles are
slowly being added everytime I update my database.

Does anyone have any advice?

--
Mark Escandon
Production/Systems Manager
Fybon Industries

[Patrice]

What are those handles you are talking about about ? It looks more like a
file problem rather than a DB problem...

Do you have some kind of file orpation in your DB layer ?

Patrice

--

"Mark Escandon" <Ma**********@discussions.microsoft.com> a écrit dans le
message de news:DB**********************************@microsof t.com...

I'VE POSTED THIS BEFORE BUT I STILL HAVE THE PROBLEM-

I wrote a database client with vb.net. It runs fine for about a week and
then I loose all connectivity. Windows NT displays a system error "no more internal File identifiers".
I checked my program carefully to make sure that every odbc and streamreader is closed after I open them; However,Using process explorer, I can see that about 15 handles get added everytime I add a record.

I force a system.gc.collect and I still see no difference; handles are
slowly being added everytime I update my database.

Does anyone have any advice?

--
Mark Escandon
Production/Systems Manager
Fybon Industries

[Willy Denoyette [MVP]]

"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

What are those handles you are talking about about ? It looks more like a
file problem rather than a DB problem...

Do you have some kind of file orpation in your DB layer ?

Patrice

Some people call Access a database too;

Willy.

[Patrice]

Mark specifically refers to "handles" not "connections". Based on this and
the error message that looks like ERROR_NO_MORE_SEARCH_HANDLES
(http://msdn.microsoft.com/library/de...-us/debug/base
/system_error_codes__0-499_.asp) I would thought rather about something like
having temporary files created but not deleted etc...

I would suggest to Mark to write a specific very simple test app that update
its DB (whatever it is) repeatedly to see if it has the same behavior...
Some tools at www.sysinternals.com (such as filemon) may also help.

Patrice
--

"Willy Denoyette [MVP]" <wi*************@telenet.be> a écrit dans le message
de news:eE**************@TK2MSFTNGP12.phx.gbl...

"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

What are those handles you are talking about about ? It looks more like a file problem rather than a DB problem...

Do you have some kind of file orpation in your DB layer ?

Patrice

Some people call Access a database too;

Willy.

[Willy Denoyette [MVP]]

"Patrice" <no****@nowhere.com> wrote in message
news:%2******************@tk2msftngp13.phx.gbl...

Mark specifically refers to "handles" not "connections". Based on this and
the error message that looks like ERROR_NO_MORE_SEARCH_HANDLES
(http://msdn.microsoft.com/library/de...-us/debug/base
/system_error_codes__0-499_.asp) I would thought rather about something
like
having temporary files created but not deleted etc...

I would suggest to Mark to write a specific very simple test app that
update
its DB (whatever it is) repeatedly to see if it has the same behavior...
Some tools at www.sysinternals.com (such as filemon) may also help.

Patrice

And connections have handles, IMO (could be wrong though) Mark has a file
based DB (like MSACCESS) located on a file share. The error 113 is typical
in this scenario and comes from the fact that the redirector (network
client) and the server (network file server) have their own file handle
administration, the number of files that can be opened over a network is
smaller than the number that can be opened locally, failing to close the
handles (close the DB connection/table etc) can lead to error 113.

Willy.

[Patrice]

Could be though he said he closed all its DB connections... (don't know how
he checked this).

Hopefully he'll be back here if needed...

Patrice

--

"Willy Denoyette [MVP]" <wi*************@telenet.be> a écrit dans le message
de news:On**************@tk2msftngp13.phx.gbl...

"Patrice" <no****@nowhere.com> wrote in message
news:%2******************@tk2msftngp13.phx.gbl...

Mark specifically refers to "handles" not "connections". Based on this and the error message that looks like ERROR_NO_MORE_SEARCH_HANDLES
(http://msdn.microsoft.com/library/de...-us/debug/base /system_error_codes__0-499_.asp) I would thought rather about something
like
having temporary files created but not deleted etc...

I would suggest to Mark to write a specific very simple test app that
update
its DB (whatever it is) repeatedly to see if it has the same behavior...
Some tools at www.sysinternals.com (such as filemon) may also help.

Patrice

And connections have handles, IMO (could be wrong though) Mark has a file
based DB (like MSACCESS) located on a file share. The error 113 is typical
in this scenario and comes from the fact that the redirector (network
client) and the server (network file server) have their own file handle
administration, the number of files that can be opened over a network is
smaller than the number that can be opened locally, failing to close the
handles (close the DB connection/table etc) can lead to error 113.

Willy.

[Willy Denoyette [MVP]]

"Patrice" <no****@nowhere.com> wrote in message
news:ea**************@TK2MSFTNGP10.phx.gbl...

Could be though he said he closed all its DB connections... (don't know
how
he checked this).

Hopefully he'll be back here if needed...

Patrice

--

He said it runs fine for about a week so I guess we will have to wait.

Willy.