string connectionString = "DSN=MyData64UNICODE;UID=scott;PWD=tiger";
                using (OdbcConnection dbconn = new OdbcConnection(connectionString))
                {
                    dbconn.Open();
                    using (IDbCommand dbcmd = dbconn.CreateCommand())
                    {
                        string sqlstr = @"SELECT 
                       sales.channel AS channel,
                       sales.custid AS customer,
                       sales.discount AS discount,
                       sales.grev AS grev,
                       sales.netrev AS netrev 
                      FROM mysales.sales sales
                      LIMIT 100";
                      dbcmd.CommandText = sqlstr;
                       using (var reader = dbcmd.ExecuteReader())
                       {
                         while (reader.Read()) // <---------------------------
                         { 
                                Console.WriteLine("Field 1: " + reader.GetValue(1));
                         }
                      }