Thanks.


>You can't really verify this from the DB side. You need to do it from the application server.
>
>In your DSN string set the max number of connections to comething really low (say 2), and set the timeout to something quite high say 300 (5 minutes) and then try to establish 3 parallel connections. On attempting the 3 connection you should get a timeout error. If not then something is wrong.
>
>Mace
>
>>Hi Macer,
>>
>>Thank you very much for your response.
>>We have already code our application using connection poolling.
>>
>>I want only to know if the connection poolling works properly.
>>
>>How I could check if my connection poolling works?
>>How I could verify it in the database connection?
>>Or there are tools that can be use to verify if the connection poolling really works.
>>
>>
>>>See this article: http://www.microsoft.com/windows2000/en/server/iis/default.asp?url=/windows2000/en/server/iis/htm/asp/iiwadata.htm
>>>
>>>If your app is using ODBC, you will need to check the registry and make sure that the CPTimeout setting has a value.
>>>
>>>Mace
>>>
>>>>Hi All,
>>>>
>>>>How I could determine if the connection to my database is using connection pooling?
>>>>What tools I can use to check it?
>>>>We have application that using connection pooling.
>>>>But I want to know if the connection pooling really use by the application.
>>>>How I could verify?
>>>>
>>>>
>>>>Thanks,
>>>>
>>>>
>>>>Rene