Please could someone help me on similar/same issue?
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 2] 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 onlly diffrence was
...Windows x86 is installed properly...
...Windows x64 is installed properly...
Thank you! Wojciech