title: Oracle VBA connection string
body: <p>How does one properly establish a connection string for integrating a macro-enabled PowerPoint to be able to query an Oracle database? I have seen many old youtube videos and online tutorials regarding this (mostly in excel), but the connection string appears differently in each one. I am using a 64 bit Windows machine and an Oracle database that I usually access through SQL Developer.</p>
  <p>A reference link that appears to be in the right direction:</p>
  <p><a href="http://learnexcelmacro.com/wp/2011/11/oracle-connection-string-in-vba/" rel="nofollow noreferrer">http://learnexcelmacro.com/wp/2011/11/oracle-connection-string-in-vba/</a></p>
  <p>I am trying to use a connection with the service, so it should look something like this:</p>
  <p><a href="https://i.stack.imgur.com/MU0Zu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MU0Zu.png" alt="enter image description here" /></a></p>
  <p>The only changes that I have personally made to the connection string are:
  HOST is Hostname founder in SQL Developer instance properties
  Port is Port in SQL Developer instance properties
  Uid is username in SQL Developer instance properties
  Pwd is password in SQL developer instance properties</p>
  <p>I have left all other fields unchanged. It should be noted that <strong>I do in fact have Tools&gt;References&gt;Microsoft ActiveX Data Objects 2.8 Library</strong></p>
  <p>I understand that inside of SQL Developer you can view the properties for a database instance connection. Is all the information there to construct my connection string? I cannot get the connection string to work and I am constantly met with errors.</p>
  <p>Thanks!</p>