title: Changing Application Name on SQL Server Connection
body: <p>Can the Application Name passed to SQL Server (via the ADO Connection string) be changed once the connection is open without closing and re-opening the connection?</p>
  
  <p>In particular, I'm using ADO, not ADO.NET, and the SQLOLEDB.1 OLE DB Provider.</p>
  
  <p>We embed the session information in the Application Name, to help us identify the connection specific to a user's session.  This primarily helps when troubleshooting bad queries or performance issues.</p>
  
  <p>We currently do not use a connection pool for our ADO connections.  I'm considering implementing a connection pool, but would like to update the Application Name when a connection is removed from the pool, so that we have accurate session information in the Application Name.</p>