Connection pooling for an Access database

  • Thread starter Thread starter Simon Harvey
  • Start date Start date
S

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
 
Hi Simon,

It is a feature of OleDb in case of Access.
And yes, it should be supported.
 
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."
 
Back
Top