0

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?

6
  • My bet is on 32 vs. 64 Bit OleDb driver issue.
    – Filburt
    Commented May 27, 2020 at 7:38
  • @Filburt how can I resolve this?
    – dex
    Commented May 28, 2020 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
    Commented May 28, 2020 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
    Commented Jun 1, 2020 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
    Commented Jun 1, 2020 at 11:17

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.