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?

  • My bet is on 32 vs. 64 Bit OleDb driver issue. – Filburt May 27 '20 at 7:38
  • @Filburt how can I resolve this? – dex May 28 '20 at 11:11
  • Use the x64 cmd (the one you simply open Win Start Menu) and the 32-Bit (the one located at C:\Windows\SySWOW64\cmd.exe) and try tnsping your Oracle database instance. This will show which drivers work and which don't. Since Visual Studio for SSIS 2008 is a 32-Bit process, it cannot "see" x64 Oracle OleDb drivers. – Filburt May 28 '20 at 12:18
  • I think your answer is helping me currently, because through the tnsping, I could find which tnsnames.ora file was being used, and configured it. – dex Jun 1 '20 at 11:15
  • I still haven't tried with an SSIS package, due to network related problems, can you please put your comment as an answer so I can mark it as the solution when I test. – dex Jun 1 '20 at 11:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.