I'm unable to connect to Oracle using the Oracle Tools for Visual Studio, with the message "Oracle Developer Tools For Visual Studio is not configured properly. Do you want to fix the configuration?" or, if I continue without repairing', "An unexpected error occurred in the ODP.NET, Managed Driver. Please contact the provider vendor to resolve this problem." Detailed steps to reproduce are below, do you have any suggestions? I've been noodling around with this for a couple of days, and seem to be getting nowhere. I CAN connect with an Oledb connection (OraOLEDB.Oracle).
Environment: Windows 10 x64 (1709), Visual Studio 2017 version 15,9.11, Oracle Data Tools for Visual Studio 2017 v. 18.3.0.0
Error message:
Error Message #1
---------------------------
Microsoft Visual Studio
---------------------------
Oracle Developer Tools for Visual Studio
Oracle Developer Tools For Visual Studio is not configured properly. Do you want to fix the configuration?
---------------------------
Yes No
---------------------------
Error Message #2
---------------------------
Microsoft Visual Studio
---------------------------
An unexpected error occurred in the ODP.NET, Managed Driver. Please contact the provider vendor to resolve this problem.
---------------------------
OK
---------------------------
Steps to reproduce:
1. Start Visual Studio, Create new .Console App (NET Framework) -- using .net 4.5.2 (I've also tried with 4.8 and a couple other that I can'r remember, error remains the same)
2. Go to server manager, right click Data Connections, get error message #1, Say yes to the dialog
3. When Oracle Developer Tools for Visual Studio Configuration Wizard pops up, close all visual studio windows and then hit Next
4. Wait a while, then at the end, I get "Successfully updated Oracle Developer Tools configuration for Visual Studio 2017", Close the window
5. Goto 1
If I say No on step 2, continue with:
1) When the Choose Data Source window comes up, choose <other> and then ODP,NET (Managed Proveder),
2) At the Add Data Connection window, use (names changed to protect the innocent) "data source=someserver:1521/db.company.com;Connection Timeout=240;Max Pool Size=200;persist security info=True;user id=WHATEVER;password=IWISHIWASUSINGSQLSERVER".
3) Hit Test connection. Smile because it worked, message "Test connection succeeded"
4) Hit OK, then get error message #2. Question your career choices.