Microsofthi,
I'm experiencing issues connecting with one of our Oracle sources
Visual studio is crashing when I try to test the connection. (This is happening in multiple PCs where we have tried)
To rule out as much as possible I have tried:
1. Change the connection to point to another oracle server: it works
2. Connect to the failing oracle server with a different tool (SQL Developer): it works
3. ping the tns with tnsping: it works
4. Deployed a failing package to a SQL Server 2017 and run: it works
I'm using Visual studio 16.8.1
integration services 3.10
Connection manager for oracle (this) version 1, 32 and 64 bit installed
Attunity 5, 32 and 64 bit
Visual studio crashes when I try with target version 2019 and 2017
The same server worked fine until some change was done by the provider which required to change tns entry on tnsnames file in our side
But as I said before the connection is working when using other tools from the same machine or when packages are deployed on a SSIS 2017 server with Attunity 5 installed
It is only from VS that it is failing even though it worked before the tns change
