Error while connecting to oracle 12c db using vb script
<p>I am trying to connect to 64 bit Oracle 12c database from VB script and code used is shown below.'Oracle in OraClient12Home1' is  the 64 bit driver installed in my system and i am running script in 64 bit command prompt.  </p>

<p>Script throws error message '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Microsoft oledb provider for ODBC drivers'</p>

<p>Can some one help me to troubleshoot the issue? </p>

<p>Code - </p>

<pre><code>strConnectionString="Driver={Oracle in OraClient12Home1}; " &amp; _
        "CONNECTSTRING=(DESCRIPTION=" &amp; _
        "(ADDRESS=(PROTOCOL=TCP)" &amp; _
        "(HOST="&amp; strDBhost &amp;")(PORT="&amp; strDBPort &amp;"))" &amp; _
        "(CONNECT_DATA=(SID="&amp; strDBService &amp;"))); uid="&amp;strUserID &amp;";pwd="&amp; strPassword &amp;";"

Set ADODBConnection = CreateObject("ADODB.Connection")

ADODBConnection.ConnectionString = strConnectionString 
ADODBConnection.Open strConnection
</code></pre>