all groups > dotnet general > december 2003 >
You're in the

dotnet general

group:

Connection pooling for an Access database


Connection pooling for an Access database Simon Harvey
12/23/2003 8:46:36 PM
dotnet general:
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

Re: Connection pooling for an Access database Miha Markic
12/24/2003 10:18:18 AM
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

[quoted text, click to view]

Re: Connection pooling for an Access database Simon Harvey
12/24/2003 1:37:53 PM
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

Re: Connection pooling for an Access database Miha Markic
12/24/2003 3:10:10 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button