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?

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

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.