Good article Andy. My apps use common code for connection strings so adding this would be easy for me. As I do not have a large user base for my apps I track usage by workstation ID/database and a quick phone call usally identifies what the user is doing. Must admit though I have been using the app/page name addition in asp for some years (not to steal your thunder though!) and makes diagnosing easy but as already stated it will increase your connections from web server even with connection pooling.

BTW I did read somewhere (can't remmeber where) that there were problems with switching on connection pooling with the later versions of MDAC which cause connection failure and network errors.

Edited by - davidburrows on 08/01/2003 02:25:48 AM