title: ODBC ConnectionString
body: <p>I have written a program in C# to pull some data using OdbcConnection :</p>
  
  <pre><code>using System.Data.Odbc;
  ......
  
  OdbcConnection OdbcConn = 
                  new OdbcConnection(Properties.Settings.Default.ConnectionString);
  OdbcCommand cmd = new OdbcCommand();
  
  //open connection 
  if (OdbcConn.State != ConnectionState.Open)
  {
      OdbcConn.Open();
  }
  </code></pre>
  
  <p>In my settings file, I have this ConnectionString: </p>
  
  <p><code>Dsn=****;uid=userID;pwd=password</code></p>
  
  <p>However I cannot establish a connection. I have an iseries access driver from IBM corp installed, but if I try MS access then I am able to connect. Any suggestions?</p>