Connection Pooling Question

Hi,
I was asking in one Technical Test, the question is not exactly like,but i want post the outline of that(because i don't remember the exactone)
Suppose u have connection with Sql Server database, and let say some 30users are already connected (through some aspx page), if one more newrequest is coming, is it created new path or it will reallocate ordestroy existing connection poll and assign??
Can anybody tell me?
if possible please post some of Basic and Adavanced questions regarding Sql Server (with aspx)
Thanks
Jen

It will reallocate the connection depending on how many connections your web server is allowing. If it only allows 30 connections, and they are all being used, the 31st connection will error out. If you are using datasets, those connections are closed so they wont hold the connection open. If you are using a datareader, they are active connections, and will stay open until either you close them yourself (dr.close and oconn.close) or the garbage collector finally collects them.
Let me know if you have any other questions or this didnt help.
Nick

|||Hi
Thanks for help Nick.. Thats enough and i will try to fine some links to explore more about it.
Thanks