title: oracle connection string not working
body: <p>On a different oracle 11g server, this variant of connection string format works:</p>
  
  <pre><code>Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); User Id=myUsername;Password=myPassword;
  </code></pre>
  
  <p>but when I use this on another oracle 11g server with similar configuration, it doesn't work anymore.</p>
  
  <p>When I use tnsping , the result comes out similar to the connection string above except the service name is blank.</p>
  
  <pre><code>Used EZCONNECT adapter to resolve the alias
  Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=ip address)(PORT=port)))
  OK (20 msec)
  </code></pre>
  
  <p>The DB is also reachable using the SQL Developer. What's wrong with my connection string? I'm working with a web service made in .NET that needs to connect to the oracle DB.</p>