title: How to set "Application Name" in ADODB connection string
body: <p>In .NET I simply use <code>Application Name = MyApp</code> inside the connection string, but when using ADO connection through VBA the Activity Monitor of the SQL Server Management Studio always shows <code>Microsoft Office 2010</code> in <code>Processes</code> on the <code>Application</code> column no matter what name I set on the VBA code.</p>
  
  
  
  <pre class="lang-vb prettyprint-override"><code>conn.ConnectionString = "UID=" &amp; UID &amp; ";PWD=" &amp; PWD &amp; ";DSN=" &amp; DSN &amp; _
      ";Application Name = MyApp"
  </code></pre>
  
  <p>How can I set the application name for monitoring purposes?</p>