I refused a disk on my PC (where I had Visual Studio 2017 Professional installed (Version 15.5.6) + Oracle client 11.2 BOOTSTRAP_COMPS = "oracle.swd.oui: 11.2.0.2.0, oracle.swd.oui.core: 11.2.0.2.0, oracle.jdk: 1.5.0.24.08 ")

After installing Visual Studio 2017 Professional (version 15.6.7) on another PC (with Oracle client 9.2) from VS \ VS17_NET, they do not connect to Oracle with the error:

ORA-12154: TNS: Unable to resolve service name

from components:

namespace Microsoft.Practices.EnterpriseLibrary.Data {public static class DatabaseFactory

and

 namespace System.Data.OracleClient { // Сводка: Предоставляет открытое подключение к базе данных. Этот класс не наследуется. [DefaultEvent("InfoMessage")][Obsolete("OracleConnection has been deprecated. http://go.microsoft.com/fwlink/?LinkID=144260", false)] public sealed class OracleConnection

But at the same time, the PL / SQL Navigator also connects via the OracleDataAdapter class too:

 namespace System.Data.OracleClient { [DefaultEvent("RowUpdated")] [Designer("Microsoft.VSDesigner.Data.VS.OracleDataAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [ToolboxItem("Microsoft.VSDesigner.Data.VS.OracleDataAdapterToolboxItem, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] public sealed class OracleDataAdapter

What is the reason and how to achieve work with the base of all classes?

  • that is, you had client version 11 - everything worked, it became 9th - it stopped working, right? - tym32167
  • You seriously think that Oracle client 9.2 will work Oracle server 11.2, it will not even work with 10) oracle.com/technetwork/topics/dotnet/downloads/index.html oracle.com/technetwork/topics/winx64soft-089540.html - Yaroslav
  • I repeat that PL / SQL Navigator connects through client 9.2 to server 11.2 and works great. The problem is that Visual Studio does not find the TNS file! Installing additional client 12.2 did not change anything! Sqlplus connects, but Visual Studio does not! - Sergey

0