Let me know if there is any other information you need to help resolve this issue.
If I try to install any of the ODT with ODAC options from Oracle, it breaks my server explorer and doesn't fix the above issue. ODAC is supposed to be part of Visual Studio now.
Pre-requisite: Install the TDV ADO.NET driver on your machine and gain access to the TDV published data source. While trying to install Visual Studio 2019 Community Edition on my laptop (Windows 10 Pro Build 19042), I experienced the good old 'installer not starting' behavior a lot of people seem to complain about for various reasons. Below is a sample C program to test a succesful connection and retrieve contents from TDV published resource. Visual Studio 2019 installer does not start if run from a folder with UTF8 characters in its name.
Researching the FAQ and other posts here, it seems that the registry entries are not set in HKEY_LOCAL_MACHINE\SOFTWARE\Oracle or HKEY_CURRENT_USER\SOFTWARE\Oracle, but I'm not sure why they are not set or what to do to correct the entries. TDV Client Drivers support connection to Visual Studio 2019. At the end of the Data Source is the port to use.
The version we are currently using is 9.9.887.0, but I think the problem is not the Devart version, but probably some missing step in the installation of Oracle ODAC or ODT, which is different in VS 2019. DBMSSOCNTCP/IP is how to use TCP/IP instead of Named Pipes. One of the best things about working with ADO.NET data providers is all data providers define the similar class hierarchy. Net data provider accesses native OLE DB providers. The "Server Explorer" in VS 2019 is able to connect to the databases in question just fine, but not the application which fails in the constructor of the ORM designer. Tagged Questions NetFx3 Installation in Windows Server 2019 Connection of ODAC 19c 64bit with Visual Studio 2019 Enterprise Installation Oracle ODAC 12.2. NET data provider provides access to ODBC data sources with the help of native ODBC drivers in the same way that the OleDb. Make sure that Oracle Client Software is installed and that the bitness of your application (x86) matches the bitness of your Oracle Client, or use the Direct mode of connecting to a server.
(Which is 12c)Įxception of type '' was thrown.Ĭannot obtain Oracle Client information from registry. The design-time features under Visual Studio 2019 are available only when you install the 32-bit Oracle Data Access Components (ODAC) with Oracle Developer. We are trying to upgrade from Visual Studio 2015 to 2019 and the application now breaks as soon as it attempts to connect to the Oracle database. I currently support two applications that have been working fine for several years.