title: Trying to connect Excel 2013 with Oracle - ORA-12154
body: <p>I am trying to connect into Oracle through <code>Power Query &gt; From Database &gt; From Oracle Database</code> and then I type <code>BI_TST</code>, which is within my TNSNAMES (located in: <code>C:\oracle\product\10.2.0\client_2\network\ADMIN</code>), and has the connection below inside:</p>
  
  <pre><code>BI_TST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = srv-oracle3.mycompany.com.br)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = bitst)
      )
    )
  </code></pre>
  
  <p>Also i have the variable path configured as <code>TNS_ADMIN=C:\oracle\product\10.2.0\client_2\network\ADMIN</code>.</p>
  
  <p>When I use SQL Developer to connect, not using TNS put setting all the information manually, it works!</p>
  
  <p>When I try to connect using TNS within Excel I get the error:</p>
  
  <pre><code>Message=ORA-12154: TNS:não foi possível resolver o identificador de conexão especificado
  
      ErrorCode=-2146232008
  </code></pre>
  
  <p>Wich means in English: "could not resolve the connect identifier"</p>
  
  <p>Could anyone please help me in this issue? </p>
  
  <p>Thanks in advance!</p>