title: DataReader already open error when trying to run two queries
body: <p>I have a couple of queries that I need to run one to a linked server and one not like this</p>
  
  <pre><code>    Dim InvestorLookup As String = "DECLARE @investor varchar(10), @linkedserver varchar(25), @sql varchar(1000) "
      InvestorLookup += "SELECT @investor = '" &amp; investor &amp; "', @linkedserver = '" &amp; db &amp; "', "
      InvestorLookup += "@sql = 'SELECT * FROM OPENQUERY(' +@linkedserver + ', ''SELECT * FROM db WHERE investor = ' + @investor + ' '')' EXEC(@sql)"
      Dim queryInvestorLookup  As SqlCommand = New SqlCommand(InvestorLookup , conn)
  
      Dim BondNoDR As SqlDataReader = queryInvestorLookup.ExecuteReader()
  
      Dim PasswordCheck As String = "DECLARE @investor varchar(10), @password varchar(20), @linkedserver varchar(25), @sql varchar(1000) "
      PasswordCheck += "SELECT @investor = '" + investor + "', @password = '" + password + "', @server = '" + db2 + "', "
      PasswordCheck += "@sql = 'SELECT * FROM @server WHERE investor = @investor AND password = ' + @password + ' '' EXEC(@sql)"
      Dim queryPasswordCheck As SqlCommand = New SqlCommand(PasswordCheck, conn)
  
      Dim PasswordDR As SqlDataReader = queryPasswordCheck.ExecuteReader()
  </code></pre>
  
  <p>As far as I can tell from debugging the queries both run as they should but I get the error</p>
  
  <pre><code>There is already an open DataReader associated with this Command which must be closed first.
  </code></pre>
  
  <p>Is it possible to run two queries in two different DataReaders. I need to later reference each DataReader and select values from each.</p>