JDBC connectivity to oracle database in UFT
<p>I am facing an issue while trying to establish JDBC connectivity to Oracle Database using VBscript code in UFT 12.02. Tried installing Oracle Driver for RDB Thin as well as Oracle 11g Client. </p>

<p>Error displayed is :  </p>

<blockquote>
  <p>[Microsoft][ODBC Driver Manager] Data source name not found and no
  default driver specified</p>
</blockquote>

<p>OR</p>

<blockquote>
  <p>TNS adaptor not found</p>
</blockquote>

<p>Connection string used is :  </p>

<pre><code>Set con= CreateObject("ADODB.Connection")  
strConnectionString = "DRIVER=oracle.jdbc.OracleDriver;URL=jdbc:oracle:thin:@&lt;HOST NAME&gt;:1521:TEMPdatabase;uid=username;pwd=password"

strConnectionString= "DRIVER={Oracle Driver for RDB Thin};URL=jdbc:oracle:thin:@&lt;HOST NAME&gt;:1521:TEMPdatabase;uid=username;pwd=password"
</code></pre>

<p>Also note that I am able to access the DB manually through DBVisualizer by creating a new Driver using Tools>Driver Manager>Create Driver and linking it to rdbthin.jar file from local drive</p>

<p>Please help me out with this issue</p>