CODEWITHSUNDEEP
ssis
SaruM
SaruM

Reputation:

Connecting to Oracle from SSIS on Vista 64 bit

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.

Upvotes: 2

Views: 6641

Answers (3)

user1617237
user1617237

Reputation: 143

Choose Run-Time when install the Oracle client which will give you Net Manager to set up TNSNames and such. 32 Bit Client for Windows

Upvotes: 0

jelong
jelong

Reputation:

You have to install Oracle client 32bit & 64bit both version..

Please refer to the link: http://knol.google.com/k/jeyong-park/accessing-oracle-data-source-from-64bit/3vywlm4f31xae/12

Upvotes: 0

Ed Harper
Ed Harper

Reputation: 21495

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.

Upvotes: 1

Related Questions