I have installed the Professional version of Visual Studio 2019 and I am unable to connect to Oracle DB Source using the Microsoft connector. I am getting the below error. Can someone please help with this?
TITLE: Microsoft Visual Studio
------------------------------
There was an error trying to establish an Oracle connection with the database server.
------------------------------
Below is all the version information
SQL Server Version Info
SQL Server Management Studio 15.0.18410.0
SQL Server Management Objects (SMO) 16.100.47008.0
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.17763
Oracle Client version installed 12
Visual Studio Version Info
Microsoft Visual Studio Professional 2019 (2)
Version 16.11.15
Microsoft SQL Server Integration Services Designer
Version 15.0.2000.123
Connectors installed
Attunity connector v5 installed but not visible in the SSIS toolbox
Microsoft Connector for Oracle v1 Installed and visible
I have specified the Oracle Home path in the connector properties below. Add path to both OracleHome and OracleHome64 and is has started to pick the correct Oracle Home.
Another resolution suggested below did work as well. I didnt even need to use the Oracle Client. Updating the tnsname with the below format working smoothly in VS2019 and VS2017.