Connection Pooling & MS Access.

Question

Can I dynamically change connection pooling parameters? Sometimes, I have error, when close connection. Thanks In Advance! Jon. http://www.naptaxes.com/AAJ/ [Searching jobs from your desktop and automatically sends resume.] --------------------------------------------------------------------------------

spgilmore · Answer

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.

Connection Pooling & MS Access.

Answers (1)