title: 'System.IndexOutOfRangeException' followed by 'System.Reflection.TargetInvocationException'
body: <p>I always get this 2 errors when executing a query</p>
  
  <pre><code>A first chance exception of type 'System.IndexOutOfRangeException' occurred in MySql.Data.dll
  </code></pre>
  
  <p>Followed by</p>
  
  <pre><code>A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
  </code></pre>
  
  <p>This is how I execute my query</p>
  
  <pre><code>Sub Get_Teller_Num(hardware_Add As String)
  
      Check_DB_Con() 'Check if the connection is okay
      SQL_Query = "SELECT teller_info.teller_num, service_info.service_num " _
          &amp; "FROM service_info " _
          &amp; "JOIN teller_info " _
          &amp; "ON service_info.service_id = teller_info.teller_id " _
          &amp; "WHERE teller_info.hardware_add = " &amp; hardware_Add
      Dim MySQL_CMD As New MySqlCommand(SQL_Query, MysqlConn)
  
      Try
          MySQL_CMD.Connection.Open()
          MySQL_Reader = MySQL_CMD.ExecuteReader()
  
          While MySQL_Reader.Read
              teller_Num = MySQL_Reader("teller_info.teller_num")
              service_Num = MySQL_Reader("service_info.service_num")
          End While
          MySQL_Reader.Close()
      Catch myerror As MySqlException
          Console.WriteLine("Failed to run query: " &amp; myerror.Message)
      Finally
          MysqlConn.Close()
          MysqlConn.Dispose()
      End Try
  End Sub
  </code></pre>
  
  <p>As you can see, I am joining another table so I can get certain values to it.</p>