HANDLES NOT BEING RELEASED

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Patrice said:
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
Click to expand...

Some people call Access a database too;

Willy.
 
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/default.asp?url=/library/en-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
 
Patrice said:
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/default.asp?url=/library/en-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
Click to expand...

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.
 
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
 
Patrice said:
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
Click to expand...

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

Willy.
 
Back
Top