title: Delphi 7 and oracle (oraoledb)
body: <p>I developed an application that uses Delphi 7, ADO and ORACLE, the provider I use is OraOLEDB.
  What do I need to install to connect to oracle server. (list apps or drivers please)</p>
  
  <p>OS : Win7 64x
  Delphi : 7</p>
  
  <p>I installed OraOLEDB_90101 from Oracle site. so I can see OraOLEDB in adoConnection in delphi.
  I define TNS_Admin in environment variables (system &amp; user) : D:\oracle\ora90\network\ADMIN
  my tnsnames.ora is :</p>
  
  <pre><code>DS2 =
  (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.254.50)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SID = ict)
    (SERVER = DEDICATED)
  )
  )
  </code></pre>
  
  <p>I also define "10.1.254.50  ds2" in hosts (C:\Windows\System32\drivers\etc).
  I can "tnsping ds2" in command prompt but whenever I add ADOConnection in a form and set the connectionString to : "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=tehranvu;Data Source=ds2" and select connect to TRUE, the error message raises : "ORA 12154: TNS: could not resolve service name.".
  I created a UDL file and the "test Connection" is OK. (copying the connection string from udl file doesn't work) !!!!</p>
  
  <p>I set connection string to :  </p>
  
  <pre><code>"Provider=OraOLEDB.Oracle;Persist Security Info=True;
   UserId=xxxx;Password=xxxx;Data       Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = 
   (PROTOCOL = TCP)(HOST = DS2)(PORT = 1521)))(CONNECT_DATA =(SID = ict)(SERVER = 
   DEDICATED)(SERVICE_NAME=DS2)))"  
  </code></pre>
  
  <p>But it raises the same error!!!</p>
  
  <p>What other apps or drivers should I install (for example Oracle Client, ...) to resolve "service name" in delphi?</p>