Pooling Connection String

1 Aug 2006 8:17 PM

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

1 Aug 2006 8:20 PM

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.

<ajay.kal***@gmail.com> wrote in message
Show quote

news:1154463446.989115.157110@s13g2000cwa.googlegroups.com...
>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
>

3 Aug 2006 4:38 AM

thejamie

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.

--
Regards,
Jamie

Show quote

"ajay.kal***@gmail.com" wrote:

> 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
>
>