Hi,

    I would like to know if there is any way to create Connection Pool for 

the DB Connections in an ASP Page are can be used by asp pages, if there 

is an example, would you please show me how to do it, I really need that.



Thanks alot

Hi there,



If you are using OLEDB to connect to your database (recommended method, by 

the way) connection pooling is turned on by default.

That means that whenever you close a connection and set it to nothing, it 

is not actually destroyed but returned to a pool where it will stay until 

the connection is reused or times out (I believe that the default time is 

90 seconds, but I could be wrong).



So, for you as a developer, you don't have to do anything extra to use 

Connection Pooling.



Please check out the following articles:



http://support.microsoft.com/support/kb/articles/Q191/5/72.ASP



http://msdn.microsoft.com/library/default.asp?

URL=/library/techart/pooling2.htm



http://msdn.microsoft.com/library/periodic/period99/basics0599.htm



Hope this helps,



Imar





> Hi,

>     I would like to know if there is any way to create Connection Pool 

for 

> the DB Connections in an ASP Page are can be used by asp pages, if there 

> is an example, would you please show me how to do it, I really need that.

> 

> Thanks alot