Enable and Disable ADO.NET and OLEDB Connection Pooling In .Net

 This article will show you how you can enable and disable the connection pooling in your asp.net application when you are using ADO.Net or OLEDB connection for your .net application.

Some of my previous articles are as follows: Reading XML Document in C# Using Linq With Where Clause In Asp.Net, Reading XML Document in C# Using Linq and Bind To GridView In Asp.Net, Export GridView Or Table Data Into jSon Format Data By C#.Net In Asp.Net Using jQuery, Retrieve Connection String From Web.config In ASP.net Using C#.Net (AppSettings,ConnectionStrings), Html Table With Its Attributes Or Css Table Attributes, Access Hidden Or HiddenFor Fields Value At Controller End In Asp.Net Mvc Using C#.

So First we will see how we can enable and disable connection pooling in ADO.NET. Please check the connection string.

Data Source=localhost;Integrated security=SSPI;Initial Catalog=DBname;Pooling=true;

In above connection string please check he Pooling=true. So if pooling is true on that case pooling is enable, and if we make Pooling=false. On that case it will be disabled.

Now let’s check for OLEDB connection.

Provider=SQLOLEDB;OLE DB Services=-4;Data Source=localhost;Integrated Security=SSPI;

So in case of OLEDB if we want to disable the pooling we need to make the OLE DB Services=-4.

I hope this article will help you to understand how to enable and disable the connection pooling in your .net application connection string.