title: Connection string to connect to oracle 11g from classic asp
body: <p>I set up an ODBC connection using ODBC Data Source Administrator . I have named it "BIOTPL" connect like this:</p>
  
  <p><a href="https://i.stack.imgur.com/fXfEV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fXfEV.png" alt="enter image description here"></a></p>
  
  <p>The corresponding code is : </p>
  
  <pre><code>Set Conn = Server.Createobject("ADODB.Connection")  
  Conn.Open "Provider=OraOLEDB.Oracle;Data Source=simple_dsn;User Id=USER;Password=PASSWORD;"
  </code></pre>
  
  <p>But I am getting this error . </p>
  
  <pre><code>ORA-12154: TNS:could not resolve the connect identifier specified
  </code></pre>
  
  <p>How can I solve this error ? Please help me . </p>