Connection Pooling

[Simon Harvey]

Hi all,

If I would like to use connection pooling in the web application that I am
making, do I need to explicitly code it, or does it just magically happen
behind the scenes?

Do I have to use ADO.net in any particular way to make sure that it happens?

Many thanks to anyone who can advise

Thanks

Simon

 

[Mary Chipman]

There is good coverage of the topic in Help, for example see the topic
"Connection Pooling for the .NET Framework Provider for SQL Server" if
you are using SQLS. The other providers are covered as well.

--Mary

 

[Paul Clement]

¤ Hi all,
¤
¤ If I would like to use connection pooling in the web application that I am
¤ making, do I need to explicitly code it, or does it just magically happen
¤ behind the scenes?
¤
¤ Do I have to use ADO.net in any particular way to make sure that it happens?
¤

No, it is available by default as long as it is supported by the database provider you are using.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Simon Harvey]

Thanks all


Simon