Connection pool size for OleDB provider

[feng]

My application is using OleDB provider and I want to
control the connection pool. I know if I want the same
thing with SQL Server provider, all I need is doing
something like "...Pooling=true;Enlist=false;Max Pool
Size=50;Min Pool Size=10" in the connection string. But
obviously, this doesn't work for OleDB provider.

Can someone tell me how to achieve that result?

Thanks!

 

[Patrice]

What exactly is the option that doesn't work ? My personal preference is to
leave the default pooling valuesunless you really want to meet something
special.

Patrice

 

[feng]

I just need to give my clients the capability to configer
the size of the pool, like I do with SQL server provider.
When I do this (Min Pool Size=10, for instance,) in the
connection string, it works for SQL Server provider, but
not for OleDB provider. That's all.

Any ideas?

 

[William \(Bill\) Vaughn]

Each OLE DB provider implements connection pooling in their own way. AFAIK,
SQL Server is the only provider that permits you to tune the behavior of the
connection pool through the connection string.
Again, tuning the pool is not something that I let my "users" do.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

I just need to give my clients the capability to configer
the size of the pool, like I do with SQL server provider.
When I do this (Min Pool Size=10, for instance,) in the
connection string, it works for SQL Server provider, but
not for OleDB provider. That's all.

Any ideas?

 

[Patrice]

Let the administrator configure the whole connection string.

Accoding to
http://msdn.microsoft.com/library/d...conconnectingtooledbdatasourceusingadonet.asp,
it looks like these properties are not available (they are specified
explicitly in both the managed SQL Server or Oracle provider but not in the
OleDb provider configuration).

It look like you can't control these properties (unless with specific oledb
db properties for example to disable pooling, it would be ole db
services=<some value>).


Patrice
--

"feng" <[email protected]> a écrit dans le message de
I just need to give my clients the capability to configer
the size of the pool, like I do with SQL server provider.
When I do this (Min Pool Size=10, for instance,) in the
connection string, it works for SQL Server provider, but
not for OleDB provider. That's all.

Any ideas?