I have a new installation of Windows Server 2016. I installed Oracle 12c (12.2.0.1.0).
Using a second computer, I tested the connection to the database using SQL Developer with success.
In the second computer, I installed Visual Studio 2017 Community (15.7.5) and ODAC for Visual Studio 2017 (12.2.0.1.1), and have run the "InstallALLOracleASPNETProvider.sql" in the database using the SQL Developer.
In Visual Studio, I try to create a new server connection using "ODP.NET, Managed Driver". I select "EZ-Connect" and fill in the same data from my SQL Developer connection.
But then an error happen. (This is a raw translation, my computer is in Spanish. I changed the IDE to English, but for some reason the text is always in Spanish)
"Oracle communication: failure to connect to the server or analyze the connection string"
What i'm missing? The textbox doesn't give any clue like "ora-XXXXX" so i'm lost.