ADO .Net : After closing my oracle connection, it remains open on the oracle server. How can I close it ?
Posted on 2004-03-23
I'm working with ASP .Net and WebServices.
In my webservice, I have an OracleConnection object.
I open that connection in the beginning of a lot of functions, and close it a the end of each function.
I thoses functions, I generaly made some updates, inserts, on select of single line results.
So I never use DataAdapters nor dataSet.
But, even if I close my connection at the end of each function, the connection remains open on the oracle server.
I guess this is due to the connection pooling.
But I wan't to definitly close my connection.
(because I sometimes reach the max connection on the oracle server)
How can I do that ???
Thanks to all of you.