>>I read the article you provided and now understand (conceptually) how the connection pool works. Sounds great. In fact I am rewriting my ASP.NET app to work with SQL Server as backend (currently it works with VFP data) and will look for an article on how to actually implement the connection pool.
>
>I think you should leave that to SQL Server. Why or what is the reason to be able to control it?
I am sure it is because I don't understand how it works. I thought that in order for my ASP.NET application to use the Connection pool I have to use a certain class of .NET, correct or not? So this is what I mean by "implement" is to call a method of this ASP.NET class that will use the connection pool. Am I completely off the target? Please let me know.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham