---
title: "Disabling Connection Pooling"
url: "https://osherove.com/blog/2003/6/22/disabling-connection-pooling.md"
canonical: "https://osherove.com/blog/2003/6/22/disabling-connection-pooling.html"
published: "2003-06-22T19:11:00"
updated: "2003-06-22T19:11:00"
tags: [".Net Original", "Tips & Tricks"]
author: "Roy Osherove"
description: "ADO.NET Data Providers automatically use connection pooling turned on. If you want to turn this functionality off: In an SQLConnection object, Add this to the connection string: Pooling=False; In An OLEDBConnection…"
usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)."
license: "https://creativecommons.org/licenses/by/4.0/"
---

# Disabling Connection Pooling

By Roy Osherove June 22, 2003 In [.Net Original](https://osherove.com/blog/category/net-original), [Tips & Tricks](https://osherove.com/blog/category/tips-tricks)

**Historical article** · Originally published June 22, 2003; technical details may be outdated.

ADO.NET Data Providers automatically use connection pooling turned on. If you want to turn this functionality off:

In an _SQLConnection_ object, Add this to the connection string:

**Pooling=False;**

In An _OLEDBConnection_ object, add this:

**OLE DB Services=-4;**

This way, the _OLE DB_ data provider will mark your connection so that it does not participate in connection pooling.

P.S

This post was written using Scott's new [Blogert](http://aspnetweblog.com/posts/7830.aspx).

It Rocks!

## More in .Net Original

[All posts in .Net Original](https://osherove.com/blog/category/net-original)

- Jun 29, 2003

    ### [FillSchema and AddWithKey Don't Operate As Promised?](https://osherove.com/blog/2003/6/29/fillschema-and-addwithkey-dont-operate-as-promised.html)

- Jun 27, 2003

    ### [Quick & Easy ADO.NET Speed Improvements](https://osherove.com/blog/2003/6/27/quick-amp-easy-adonet-speed-improvements.html)

- Jun 22, 2003

    ### [A Little Macro To Automate Creating Connection Strings](https://osherove.com/blog/2003/6/22/a-little-macro-to-automate-creating-connection-strings.html)

- Jun 21, 2003

    ### [Winforms Data Binding Lessons Learned](https://osherove.com/blog/2003/6/21/winforms-data-binding-lessons-learned-1.html)


---

## About the author

**Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery.

### Sites

- [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership.
- [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts.
- [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin.
- [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model.
- [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps.
- [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes).

### Social

- X: https://x.com/royosherove
- LinkedIn: https://www.linkedin.com/in/osherove/

### Contact

- Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7

### License

Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/