Connection Pooling

  • Thread starter Thread starter Sameer Motwani
  • Start date Start date
S

Sameer Motwani

Hello,
Can anyone point me to some examples of Database Connection Pooling for Ole
Db Data Sources using VB/C# .Net
I know we can achieve connection pooling using the COM+ (System.Enterprises)
Object Pooling but I just want to look at some examples before I start.


Any help would be appreciated
Sameer
 
I'm not sure what you need to see, but all of the ADO.NET Data Providers
support connection pooling by default. All you need to do is open the
connection, use it and close it. The pooler does everything else. See my
article on the details. http://www.betav.com/sql_server_magazine.htm

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Hi Sameer!

I am researching your issue now. Thanks for your patience,

Brett Keown
Microsoft Support
(e-mail address removed)

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Can I dynamically ( from code ) change connection pooling parameters?

Thanks.
-------------------------------------------------------------------------------http://www.naptaxes.com/AAJ/
[AllAmericanJobs - Searching jobs from desktop and automatically sends
resume.]
 
Yes, with the SqlClient .NET Data Provider. You can change the way that the
connection pool is created by changing settings in the ConnectionString.
This includes enabling the pooler, setting the minimum and maximum size of
the pool and other settings. Not all providers exposed these switches.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

jon said:
Can I dynamically ( from code ) change connection pooling parameters?

Thanks.
-------------------------------------------------------------------------- -----http://www.naptaxes.com/AAJ/
[AllAmericanJobs - Searching jobs from desktop and automatically sends
resume.]
-------------------------------------------------------------------------- -----


"William \(Bill\) Vaughn" <[email protected]> wrote in message
I'm not sure what you need to see, but all of the ADO.NET Data Providers
support connection pooling by default. All you need to do is open the
connection, use it and close it. The pooler does everything else. See my
article on the details. http://www.betav.com/sql_server_magazine.htm

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

for
Ole
Click to expand...
Click to expand...
 
I'll ask Angel Sanchez. He's the expert at MS on the pooler. I was under the
impression that all of the .NET providers supported pooling by default.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top