A connection pool is a set of database connections that are available for an application to use. Connection Pooling is the concept of using a connection pool for enhanced performance.
Connection Pooling is provided by MTS (Microsoft Transaction Server). Instead of creating and destroying the connections Connections are put to asleep and revoked when needed. It saves most of the System time when the connections are kept open. It provides reusability as a single connection is used many times.
Connection pooling is the ability of re-use your connection to the Database. This means if you enable Connection pooling in the connection object actually you enable the re-use of the connection to more than one user.
