Hi guys and gals,

I'm going to be using an Access database for a small program that I'm
making.

I was wondering if anyone could tell me if Access supports Connection
Pooling. I'm going to be using C# to make the application. I don't know if
connection pooling is something that is implemented within the database
itself, or whether this mechanism is done in the drivers that are used to
connect to the database.

If anyone happens to know if Access can do this then that would be great

Many thanks

Simon

Hi Simon,

It is a feature of OleDb in case of Access.
And yes, it should be supported.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Simon Harvey" <sh856531@microsofts_free_email_service.com> wrote in message
news:%(E-Mail Removed)...
> Hi guys and gals,
>
> I'm going to be using an Access database for a small program that I'm
> making.
>
> I was wondering if anyone could tell me if Access supports Connection
> Pooling. I'm going to be using C# to make the application. I don't know if
> connection pooling is something that is implemented within the database
> itself, or whether this mechanism is done in the drivers that are used to
> connect to the database.
>
> If anyone happens to know if Access can do this then that would be great
>
> Many thanks
>
> Simon
>
>

Hi

Thanks for your reply.

Do you have to do anything to swith connection pooling on, or is it
something that is just handled by the driver behind the scenes?

Thanks

Simon

It is handled by oledb by default.
Excerpt from help files:
"If you are using the OleDbConnection, OdbcConnection, or OracleConnection
class, connection pooling is handled automatically by the provider, so you
do not need to manage it yourself."

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Simon Harvey" <sh856531@microsofts_free_email_service.com> wrote in message
news:%(E-Mail Removed)...
> Hi
>
> Thanks for your reply.
>
> Do you have to do anything to swith connection pooling on, or is it
> something that is just handled by the driver behind the scenes?
>
> Thanks
>
> Simon
>
>