>Any other ideas?Did you miss my post? In Message #
925200, I said:
I think I may have found your problem. In your Page_Load there is one point where you have an open connection that you don't close (after a Transaction Rollback). That could *definitely* cause a lot of Open connections. Correct this and see if it solves your problem.
~~Bonnie
>Hector,
>
>Thanks for your response.
>
>According to:
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclientoracleconnectionclassconnectionstringtopic.asp>
>connection pooling is supported.
>
>Any other ideas?
>
>TIA
>
>Rex
>
>
>>Rex,
>>
>>I am not sure if the Oracle Client supports connection pooling. Some of the parameters for the connection strings are particular for each different provider.
>>
>>Are you sure the Oracle Client supports connection pooling?
>>
>>
>>>All,
>>>
>>>I am using the MS OracleClient and connection pooling in my 2 application. I have the min pool size set to 100 and the max pool size set to 500. The connection strings are identical. This is a test server and I am the only user, but the Oracle DBA is telling me there are 201 open connection for my user name. The 1 is from my TOAD connection, but the connection count is doubled.
>>>
>>>I am using the OracleClient from Visual Studio 2003.
>>>
>>>Has anyone had/solved this problem?
>>>
>>>TIA
>>>
>>>Rex