question

saketchouksey avatar image
saketchouksey asked

The 'OraOLEDB.Oracle.1' provider is not registered on the local machine

I have a SSIS (2005) package which was developed on a 32 bit machine. The Package connects to the oracle database and have 2 connections (1 using the MS provider for Oracle and other being Oracle Provider for Oracle). This works fine on my machine but when deployed on Production server which is a 64-bit machine and executed through a SQL server agent job it gives an error "The 'OraOLEDB.Oracle.1' provider is not registered on the local machine". I have also installed 32 bit oracle client on this machine. Inputs needed...
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
I had a similar issue about a year ago. If memory servers we installed the x64 Oracle client and the 32 side by side. We wound up using the x64 drivers but since the SQL BI DEV Studio (devenv.exe) runs in 32 bit mode, to verify the connection to ORACLE in SQL BI DEV Studio design mode ORACLE 32 client was used. There are 32 and 64 ODBC managers as well. Make sure you are looking at the correct one when confirming/making connections.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I did verify this and I am using the Oracle 32 bit client.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.