SSIS ORA-12638 Visual Studio 2017

2019-09-02 09:23发布

问题:

I am using visual studio 2017 and I am trying to create a SSIS package that connects to oracle. I am getting the ORA-12638: Credential Retrieval Failed. The server connection and the username and password that I am using works. I can connect using the same information through a linked server in SQL Management Studio and SQL Oracle Developer. I have made the SQLNET.ora change to SQLNET.AUTHENTICATION_SERVICES= (NONE). I have also ran the tnsping.exe for the server that I am connecting too and verified that I changed the correct file.

How can I make a oracle connection in SSIS to oracle?

回答1:

I had to install the Oracle Data Access Components (ODAC) bundle which includes "Oracle Developer Tools for Visual Studio" from oracle.

http://www.oracle.com/technetwork/topics/dotnet/whatsnew/vs2012welcome-1835382.html