在 Vista 64 位上从 SSIS 连接到 Oracle [英] Connecting to Oracle from SSIS on Vista 64 bit

问题描述

我正在尝试在 Vista 64 位上使用 SSIS 连接到 Oracle 数据库并收到以下错误.由于初始化提供程序时出错，测试连接失败.未找到 Oracle 客户端和网络组件.这些组件由 Oracle Corporation 提供，是 Oracle 7.3.3 或更高版本客户端软件安装的一部分.在安装这些组件之前，提供程序无法运行."

我使用的是 Oracle 10.2.0.4 64 位兼容客户端.

但是，在 32 位机器上，我能够使用 10g 32 位兼容客户端成功连接到 Oracle 源.

解决方案

该错误消息表明无法找到所需版本的 Oracle 客户端.

如果您尝试从 64 位计算机上的 Business Intelligence Design Studio 中连接到 Oracle，您还需要安装 32 位 Oracle 客户端，因为 BIDS 是一个 32 位应用程序.

I am trying to connect to an Oracle DB using SSIS on Vista 64 bit and getting the following error. "Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed."

I am using the Oracle 10.2.0.4 64 bit compatible client.

However, on a 32 bit machine I am able to successfully connect to Oracle source using a 10g 32 bit compatible client.

解决方案

The error message indicates that the required version of the Oracle client could not be located.

If you are attempting to make the connection to Oracle from within the Business Intelligence Design Studio on the 64-bit machine you will also need to install the 32-bit Oracle client, since BIDS is a 32-bit application.

这篇关于在 Vista 64 位上从 SSIS 连接到 Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！