SSIS ORA-12638 Visual Studio 2017(英文) [英] SSIS ORA-12638 Visual Studio 2017

问题描述

我正在使用Visual Studio 2017，并且试图创建一个连接到oracle的SSIS包.我收到了ORA-12638:凭据检索失败.服务器连接以及我使用的用户名和密码均有效.我可以使用相同的信息通过SQL Management Studio和SQL Oracle Developer中的链接服务器进行连接. 我已将SQLNET.ora更改为SQLNET.AUTHENTICATION_SERVICES =(NONE).我也为我要连接的服务器运行了tnsping.exe，并确认我更改了正确的文件.

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.

如何在SSIS中建立到oracle的oracle连接?

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

推荐答案

我必须安装Oracle数据访问组件(ODAC)软件包，其中包括来自oracle的用于Visual Studio的Oracle开发人员工具".

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

这篇关于SSIS ORA-12638 Visual Studio 2017(英文)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！