0 Replies Latest reply on Mar 3, 2020 2:08 AM by Christian.Shay -Oracle

    New release: ODT 19.3 Now Supports Visual Studio 2019

    Christian.Shay -Oracle

      Hi folks,

      We just released Oracle Developer Tools for Visual Studio 19.3. You can get it here:

       

      VS 2019:

      https://www.oracle.com/database/technologies/dotnet-odtvsix-vs2019-downloads.html

       

      VS 2017:

      https://www.oracle.com/database/technologies/dotnet-odacmsi-vs2017-downloads.html

       

       

      This release contains some important new features:

       

      1) Support for Visual Studio 2019, packaged in a convenient .vsix file to make installation easy.

       

      2) Oracle Autonomous Database integration with VS 2017 and VS 2019 via a Cloud Explorer node in Server Explorer. Developers can quickly create no cost Always Free Autonomous Database instances from Visual Studio, automatically download credentials files and be connected to the database to work on code within minutes. Try out Always Free ADB today, it is very cool!

       

      Learn all about the Autonomous Database integration in my blog here:

       

      https://medium.com/oracledevs/visual-studio-integration-with-oracle-autonomous-database-7c6243eca329

       

      Please start a discussion below to report issues or just to let us know what you think.

       

      Notes on this release:

       

      1) Changed Network Configuration files location (tnsnames.ora, etc):

      With the cloud, people these days have multiple locations where they store network config files (tnsnames.ora, etc). Multiple tns_admin settings. And they need to switch back and forth between them as they move from one database to another.

       

      Now, by default network configuration files are located in: C:\Users\yourusername\Oracle\network\admin

       

      You can see and change the directory it is using by looking at the Oracle Database connection dialog in server explorer (TNS Admin location)

       

      Also, you can change the default by going to the Visual Studio menu: Tools->Options->Oracle Developer Tools->Connection configuration

       

      2) No default ODP.NET TNS_ADMIN location:

      The change to default TNS_ADMIN location mentioned above applies to the tools only. In your VS project, ODP.NET no longer has a default location in which to locate the TNS_ADMIN files. You will need to set TNS_ADMIN and (if needed) WALLET_LOCATION in the config file (eg app.config, or web.config) or include the TNSNAMES/SQLNET.ORA/WALLET/etc in the root of your project.