尝试将Excel 2013与Oracle连接 - ORA-12154(Trying to connect Excel 2013 with Oracle - ORA-12154)

 我试图通过Power Query > From Database > From Oracle Database连接到Oracle，然后输入BI_TST ，它位于我的TNSNAMES（位于： C:\oracle\product\10.2.0\client_2\network\ADMIN ）中，并在下面有连接： 
 
BI_TST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srv-oracle3.mycompany.com.br)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bitst)
    )
  )
 
 我TNS_ADMIN=C:\oracle\product\10.2.0\client_2\network\ADMIN变量路径配置为TNS_ADMIN=C:\oracle\product\10.2.0\client_2\network\ADMIN 。 
 
 当我使用SQL Developer进行连接时，不使用TNS手动设置所有信息，它可以工作！ 
 
 当我尝试在Excel中使用TNS连接时，我收到错误： 
 
Message=ORA-12154: TNS:não foi possível resolver o identificador de conexão especificado

    ErrorCode=-2146232008
 
 这意味着英文：“无法解析连接标识符” 
 
 有谁可以帮我解决这个问题？ 
 
 提前致谢！ 

I am trying to connect into Oracle through Power Query > From Database > From Oracle Database and then I type BI_TST, which is within my TNSNAMES (located in: C:\oracle\product\10.2.0\client_2\network\ADMIN), and has the connection below inside:
 
BI_TST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srv-oracle3.mycompany.com.br)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bitst)
    )
  )
 
Also i have the variable path configured as TNS_ADMIN=C:\oracle\product\10.2.0\client_2\network\ADMIN.
 
When I use SQL Developer to connect, not using TNS put setting all the information manually, it works!
 
When I try to connect using TNS within Excel I get the error:
 
Message=ORA-12154: TNS:não foi possível resolver o identificador de conexão especificado

    ErrorCode=-2146232008
 
Wich means in English: "could not resolve the connect identifier"
 
Could anyone please help me in this issue? 
 
Thanks in advance!

原文：https://stackoverflow.com/questions/24809391