MicrosoftHi - really struggling getting Attunity drivers working in VS 2019 and targeting SQL 2014 (has to be that version for corporate reasons and not my decision!). We have this working on an old 2008 package and need to upgrade.
The attempts below are from creating a new simple package/solution from scratch in vs2019 (not upgrading the old one)
Set up and test connections all work, but every time I run the package in VS2019 get "The AcquireConnection method call failed with error code 0x80004005"
This is my setup:
VS2019: Version 16.6.4
SSDT installed (tick / checked in VS installer)
SSIS installed (extension) 15.0.2000.123
SQL Server Integration Services Oracle Connector - 32 bit
Attunitiy 3.0 - 32 bit (have to target SQL 2014)
Oracle InstantClient 12_2 (12c) - 32bit
TNSNAMES.ORA / SQLNET.ORA set up and successfully using TNS from other apps (eg SQL Developer / .NET c#)
SSIS Package Options:
Properties --> SQL Server 2014
--> Run64BitRuntime = false (have tried every combination with 64bit components installed and changing this)
1) ADO.NET Connection to Oracle to run SQL command - test success, execute success (using TNS name)
2) Data Flow - add either "MS ORACLE Source" OR "MS ORACLE Destination" - create an Oracle connection Manager (different to ADO.NET manager)
- can pick list to tables, test connection works ok
ERROR: But keep getting the below error when running package:
[Oracle Source [2]] Error: The AcquireConnection method call to the connection manager Oracle Connection Manager failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I've tried uninstalling everything / re-installing the 64Bit as well as having both 32/64 bit together. Same issue???
