I want to thank each of you very much. The response has been tremendous, both in quality and quantity. The technical responses have paved the way to reducing the number...

Thank you DM! Yes, I've determined that the connections are just hanging around. They do eventually drop off, but it takes a couple of hours of non-use.

Wow. This is awesome information! The developers are now telling me that the dataadapter when not used with a data reader is supposed to implicitly close the connection automatically after...

Thanks PW! It's the smart client app running on 50 individual PC's all making connectino from each PC to the server. No Web or shared components involved.

Oh, no, we don't have to do that. It's obvious the application is opening multiple connections per person. That's not really an issue. The problem is these connections are remaining...

Thanks Remi, at your suggestion, I requested a copy of their syntax template. It's used throughout the application: