Unable to connect to Oracle DB using VBS
<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>