'oraoledb.oracle.1' provider is not registered on the local machine

SSIS and Import/Export
1

Hi,

I have a 64 bit machine running win 8.1. I installed the oracle 12c 64 bit client and the 64 bit odac drivers. However, all of my oracle connections are give me the "'oraoledb.oracle.1' provider is not registered on the local machine" error.

thanks

Scott

2

I had to install both the 64-bit and 32-bit clients in order to get it to work.

3

Hi Tara,

the actual oracle clients or just the ODAC drivers?

4

got this to work after installing 32 bit Odac drivers:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

5

Woohoo!

I think 32-bit was needed because the SQL Server tools are 32-bit.