title: Unable to connect to Oracle DB using VBS
body: <p>I don't have an oracle DB installed on my machine. The DB location is on UNIX machine. I Want to run Insert queries in DB located on other VM. I had written one code iusing VB Script but that throws me an error while running the same. Please help me. Below is my code:</p>
  
  <pre class="lang-vb prettyprint-override"><code>'Save the file with &lt;filename&gt;.vbs
  
  Set dbMyDBConnection = CreateObject(“ADODB.Connection”)
  ConnectionString = “(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.30.16.31)(PORT=1521)))(CONNECT_DATA=(SID=PUNDEV11)))”
  
  strConnection = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” &amp; ConnectionString &amp; “;Jet OLEDB:Database Password=” &amp; strPassword &amp; “;User ID=” &amp; strUsername &amp; “;Password=” &amp; strPassword &amp; “;”
  
  dbMyDBConnection.Open strConnection
  </code></pre>
  
  <p>Also,  I checked replacing the provider to Microsoft.Jet.OLEDB.12.0 and OraOLEDB.Oracle.</p>
  
  <p>I am using Windows 7 64 bit platform.</p>
  
  <p>Error: </p>
  
  <blockquote>
    <p>Provider cannot be found. It may not be properly installed. Code : 800A0E7A Source : ADODB.Connection</p>
  </blockquote>