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.