Please could someone help me on similar/same issue as in this TOPIC - SSIS package that connects to an oracle DB using Attunity Connection Manager
My environment situation is:
I have installed:
(I have tried multiple time installing only 32 or only 64 versions, and uninstalling and restarting VMs) I have SSIS package with Oracle Connection Manager. In Visual Studio inside package:
IF SQL Target version is SQL 2017
Connection manager to oracle test: SUCCESS
Run Package: FAIL
ERROR in DEBUG MODE:
[OMS OrderLines ABBICS V_F_ORDERS_RO24881SRU 3] Error: The AcquireConnection method call to the connection manager Oracle DB failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: OMS OrderLines ABBICS V_F_ORDERS_RO24881SRU failed validation and returned error code 0x80004005.
Error: The ORACLE registry key cannot be opened. Verify that the Oracle Client for Windows x86 is installed properly.
I have tried running packages in 64 and 32 bit mode as well as running job in 32 bit mode. The only difference was
...Windows x86 is installed properly...
...Windows x64 is installed properly...
Thank you! Wojciech
Finally I was able to solve that uninstalling everything and install what i mentioned in post above plus:
32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio
ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (184.108.40.206.1)
This fixed issue and package can be run in both 32 and 64 bit mode
EDIT: To minimize installation components - >On machines with SQL server 2017 I did following things:
install.bat basic F:\ORACLE myhome false true
This will install Oracle Instant Client Machine Wide
This allows me run SQL jobs successfully (remember to install other components mentioned in main post!)
User contributions licensed under CC BY-SA 3.0