>Yes, there are time out values that you can set. The following article gives a good overview of how this works and how to use connection pooling to optimize scenarios like yours:
>
>http://msdn.microsoft.com/library/default.asp?URL=/library/techart/pooling2.htm

Wow, this is what I call an extensive document. I'll have to check it more once I have some time.