Pooling Connection String

[ajay.kalyan]

I am trying to implement connection pooling on web application and was
wondering what connection string I should use. I currently use:

Data Source=xxx.com,25000; Initial Catalog=xxx; UID=user;pwd=password

Should I add anything to this connection string i.e pooling=true, max
pool size, min pool size, timeout, etc.

There are so many connection strings out there and each one is
different.

Thanks

 

[Marina Levit [MVP]]

If you use the SQL client provider, pooling is on by default. Unless you
have particular requirements in your app, you shouldn't need to change
anything in the connection string. What you have is fine.

 

[Guest]

The Min Pool is to make sure there are enough available connections so that
your users aren't stuck waiting forever to grab an available connection.