Connection pooling for an Access database

[Simon Harvey]

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

[Miha Markic]

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:%2****************@TK2MSFTNGP09.phx.gbl...

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

[Simon Harvey]

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

[Miha Markic]

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:%2***************@TK2MSFTNGP12.phx.gbl...

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