Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connection pooling

Status
Not open for further replies.
Jul 29, 2005
136
PT
Hello,

I thought I had understand (sql server) connection pooling but I think I was wrong... I realize that if I start a connection, from an apllication and if I than stop the application and open it again and establish a connection, the first connection that was openning will not be used (althoug using the same connections string).

I saw in Profile that some information about the connection as changed like the client process ID... So my question is: to work with connection pooling the application need to be always opened (to maintain the same process id)? If so, what happens if the application is a dll or an asp page.

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top