title: cannot connect to oracle server from C#.net application
body: <p>I'm trying to connect to remote Oracle server. My connection string - </p>
  
  <pre><code>OdbcConnection con = new OdbcConnection();
  con.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= xxxx)(PORT=xxxxx))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=abc.domain.com)));USER ID=user1;Password=pwd;";
  </code></pre>
  
  <p>I encountered error saying - "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" (System.Data.Odbc.OdbcException)   Exception Message = "ERROR [IM002] [Microsoft][ODBC Driver Manager] <strong>Data source name not found and no default driver specified</strong>", Exception Type = "System.Data.Odbc.OdbcException", Exception WinRT Data = ""   </p>
  
  <p>I specified my connection string according to my TNSNAMES.ora</p>
  
  <p>Entry for my DB in TNSNAMES.ora goes like this: </p>
  
  <pre><code>DB.WORLD=
    (DESCRIPTION=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST= xxxx)
        (PORT=xxxxx)
      )
      (CONNECT_DATA=
        (SERVER=dedicated)
        (SERVICE_NAME=abc.domain.com)
      )
    )
  </code></pre>
  
  <p>Can someone explain on the error. Please help/suggest if my connection string went wrong and how to connect to Oracle server from my windows application</p>