title: How to use oracle Wallet and .net web api
body: <p>I am using oracle wallet for log-in into Oracle 11 DB instance, from my .net Web API 2 code.</p>
  
  <p>problem is unless I specify the user ID and password in connection string , oracle wallet throws </p>
  
  <pre><code>Error MessageORA-01017: invalid username/password; logon denied
  </code></pre>
  
  <p>which doesn't justify use of wallet! 
  I have googled much yet not much luck with any possible solution.</p>
  
  <p><strong>sqlnet.ora</strong></p>
  
  <pre><code>sqlnet.authentication_services=(NTS)
  ssl_client_authentication=false
  WALLET_LOCATION=
  (SOURCE=
   (METHOD=FILE)
   (METHOD_DATA=
       (DIRECTORY=c:\temp\wallet)
   )
  )
  </code></pre>
  
  <p><strong>Tnsnames.ora</strong></p>
  
  <pre><code>source= (DESCRIPTION=(ADDRESS=(PROTOCOL=&lt;PROTOCOL&gt;)(HOST=&lt;server hostname&gt;)PORT=&lt;PORT&gt;))(CONNECT_DATA=(SERVICE_NAME=&lt;Global DB Name&gt;)))
  </code></pre>
  
  <p>my <strong>web.config</strong> file reads the specific section as below - this way connection fails with aforesaid error</p>
  
  <pre><code>&lt;settings&gt;
  &lt;setting name="TNS_ADMIN" value="C:\ORA\TNSFILES"/&gt;
  &lt;setting name="WALLET_LOCATION" value="(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=c:\temp\wallet)))"/&gt;
  &lt;setting name="SSL_VERSION" value= "0" /&gt;
  &lt;setting name="SSL_CLIENT_AUTHENTICATION" value = "TRUE" /&gt;
  &lt;/settings&gt;
  
  &lt;connectionStrings&gt;
  &lt;add name="OracleWallet1" providerName="oracle.manageddataaccess.client"     connectionString="Data Source=source;User Id=/;" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>please suggest what could be the issue here</p>