title: How to change the default tnsnames.ora file path read by Visual Studio 2017
body: <p>Visual studio 2017 by default reads the tnsnames.ora file from the installation path of the oracle developer tools for vs2017. </p>
  
  <p>There is an option to search and then copy and replace the tns file in above default location with a different ora file in the machine. However the problem with this is, multiple tns files needs to be maintained in this case(because other oracle software reads the tns file from oracle client installation path). </p>
  
  <p><a href="https://i.stack.imgur.com/iyavw.png" rel="nofollow noreferrer">VS 2017 Search and copy tnsnames.ora file window</a></p>
  
  <p>Instead, is there a way to change the default tnsnames.ora path read by VS2017? (TNS_ADMIN and Path environment variables are already configured.)</p>