connection pool in ADO.NET

G

Grey

is the connection pooling mechanism set default in the normal connection string, i.e.

"Provider=SQLOLEDB;Server=SERVER_NAME;User ID=sa;Password=;Database=DB_NAME"

If not, what is the difference if I use connection pool and not in user and programmer point of views??


Million Thanks..
 
R

Rick Strahl [MVP]

Connection pooling is the default for SQL Server. If you use the Sql Client
the pooling key on the command line allows you to turn off pooling if you
don't want it, but it's on by default. You can also set the size of the
connection pool.

With OleDb the pooling is handled by the Sql Server OleDb driver. I'm not
sure if you can control pooling with the connection string or not, but it is
enabled by default.

+++ Rick ---

--

Rick Strahl
West Wind Technologies
http://www.west-wind.com/
http://www.west-wind.com/weblog/
----------------------------------
Making waves on the Web


is the connection pooling mechanism set default in the normal connection
string, i.e.

"Provider=SQLOLEDB;Server=SERVER_NAME;User ID=sa;Password=;Database=DB_NAME"

If not, what is the difference if I use connection pool and not in user and
programmer point of views??


Million Thanks..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top