title: What connection string do I use for Classic ASP and Oracle 10g?
body: <p>I have Oracle 10g and have installed ODBC via the instant client.  I am able to use the ODBC administrator and set up a DSN and test successfully, and whenever I use Microsoft Access I can connect to my database no problem.  I can also use Visual Web Developer to traverse the data.</p>
  
  <p>But, when I try and use Classic ASP with:</p>
  
  <p>myConn.Open "DSN=oracle10g;" &amp; _ 
  "Uid=myOracleUsername;" &amp; "Pwd=myOraclePassword"</p>
  
  <p>I get:</p>
  
  <p>-2147467259Specified driver could not be loaded due to system error 5 (Oracle in instantclient10_2).
  An error occurred while trying to create Server Object.</p>
  
  <p>I have searched various places but nothing seems to work.  All ORACLE_HOME, TNSnames, IUSR_X security, all is correct.  I am thinking it is a DSN connection string problem.</p>
  
  <p>Anyone know?</p>