different kind of connection pool issue...

i hate to beat a dead horse, but with my "timeout expired...connection pool max size has been reached... blah blah blah" error, i have found many solutions to this problem (i think).

but...i inherited this application that uses the sqlconnection object from the toolbox, and a bunch of dataadapters and stuff. I am setting the connection string (with maxpools=100) when the forms load, but this does not seem to help when clicking among a data-bound grid several times.

Since i dont have direct control over the opening and closing of connections using the data controls, how could i avoid this issue here?

george hardy
ghardy2k@yahoo.com-spmless

[777 byte] By [GeorgeHardy] at [2007-12-16]