Re: Connection isn't released on MyConnection.Close
Posted by: Karel Boek
Date: December 01, 2004 06:26AM

Here I am again; solved the problem. Sorry for bothering anyone who was chewing on the code in order to find a solution.
The problem I had is that I directly returned the "Setting" while the datareader was still reading and thus the connection
couldn't be closed. I now re-wrote my code as follows and this works fine:

Dim ReturnString as String

...

While dbDataReader.Read
ReturnString = dbDataReader.Item(Setting)
End While

...

dbConnection.Close()
Return ReturnString

Does That Make Sense?

Options: ReplyQuote


Subject
Written By
Posted
Re: Connection isn't released on MyConnection.Close
December 01, 2004 06:26AM


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.