title: How to specify "Service Name" in Oracle ODBC connection string
body: <p>I have an Excel macro that has an Oracle database connection. When I call the macro, it fills out user name and password but not service name. User has to enter service name manually every time. </p>
  
  <p>How can I specify it in the connection string?</p>
  
  <p><strong>Connection string:</strong></p>
  
  <pre><code>CN.ODBCConnection.Connection = _
  "ODBC;DRIVER={Oracle in OraClient11g_home2};" &amp; _
  "UID=" &amp; inputUser &amp; ";PWD=" &amp; inputPassword &amp; ";" &amp; _
  "HOST=" &amp; inputHost &amp; ";PORT=1521;DB=" &amp; inputHost &amp; ";" &amp; _
  "DefaultIsolationLevel=READUNCOMMITTED"
  </code></pre>
  
  <p><strong>Excel prompt:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/ZfmUz.png" alt="enter image description here"></p>