I am trying to use an Oracle OleDb source in my SSIS package with no luck, every time I try to connect to the server I get the error:
>ORA-12154 tns could not resolve the connect identifier specified
, knowing that:
1 I installed Oracle 11g express edition
2 I added an entry for the alias in my tnsnames.ora file
3 ORACLE_HOME variable pointing to my Oracle installation
4 Path & TNS_ADMIN variables pointing to the directory containing the tnsnames.ora file
5 I am using a Windows Server 2012
What am I doing wrong?
Asked by dex
(1 rep)
May 27, 2020, 07:29 AM
Last activity: May 27, 2020, 08:53 AM
Last activity: May 27, 2020, 08:53 AM