Re: Connection is closed, but not disposed or released
Posted by: Karel Boek
Date: January 24, 2005 05:38AM

Thank you for the information; I adjusted my code to include the "Finally" code as you described (see below). However, I get the impression that it doesn't help. I mean: when I go to the MySql Administrator and list the server connections, my connection is still there, although I've closed Internet Explorer for some minutes ago (connection timeout is set to 5 minutes)

Try
  dbDataAdapter.Fill(dbDataTable)
  dbConnection.Close()
Catch ex As Exception
  'Log error
Finally
  dbConnection = Nothing
End Try

Does That Make Sense?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.