Connection Pooling & MS Access.

I could only guess, but I would say no. As I understand it, connection pooling will only work with connections that have the EXACT SAME connection string (this is knowlege regarding classic ADO, not ADO.NET, so I could be wrong). Changing the connection pool parameters changes teh connection string (unless you know another way to do it). BTW, why are you using connection pooling with MSAccess? Access supports relatively few concurrent users and you might benefit from using a single connection to an Access database and just working with the one connection. It won't do you much good to use multi threading on Access and if you only use one operation at a time, you might as well just share the connection object between dataadapters or datareaders.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

spgilmore23y ago
I could only guess, but I would say no. As I understand it, connection pooling will only work with connections that have the EXACT SAME connection string (this is knowlege regarding classic ADO, not ADO.NET, so I could be wrong). Changing the connection pool parameters changes teh connection string (unless you know another way to do it). BTW, why are you using connection pooling with MSAccess? Access supports relatively few concurrent users and you might benefit from using a single connection to an Access database and just working with the one connection. It won't do you much good to use multi threading on Access and if you only use one operation at a time, you might as well just share the connection object between dataadapters or datareaders.