Re: [ADVANCED-DOTNET] ADO.NET and Connection Pooling

2002-05-10 Thread Beauchemin, Bob
ECTED]] Sent: Friday, May 10, 2002 6:53 AM To: [EMAIL PROTECTED] Subject: [ADVANCED-DOTNET] ADO.NET and Connection Pooling I've been thinking about connection pooling with the SQL Server managed provider, and have a few thoughts/questions: 1. ADO.NET connection pooling is tied to a specific pro

Re: [ADVANCED-DOTNET] ADO.NET and Connection Pooling

2002-05-10 Thread Craig Andera
> 1. ADO.NET connection pooling is tied to a specific process. > Thus, if you want to share a connection over multiple > clients, you need to host your database component in an > ASP.NET application or through .NET Remoting (and pay the > price of the extra network call), right? Yes. This is, in

[ADVANCED-DOTNET] ADO.NET and Connection Pooling

2002-05-10 Thread Matthew
I've been thinking about connection pooling with the SQL Server managed provider, and have a few thoughts/questions: 1. ADO.NET connection pooling is tied to a specific process. Thus, if you want to share a connection over multiple clients, you need to host your database component in an ASP.NET a