title: How can I solve a max pool size - ASP.NET
body: <pre><code>Public Function QueryDataSet(ByVal strSQL As String) As DataSet
      Dim ds As New DataSet
      Dim dtAdapter As New SqlDataAdapter
      objConn = New SqlConnection
      With objConn
          .ConnectionString = strConn
          .Open()
      End With
      objCmd = New SqlCommand
      With objCmd
          .Connection = objConn
          .CommandText = strSQL
          .CommandType = CommandType.Text
      End With
      dtAdapter.SelectCommand = objCmd
      dtAdapter.Fill(ds)
  
      objConn.Close()
      objConn.Dispose()
      SqlConnection.ClearPool(objConn)
      objConn = Nothing
      Return ds 
  End function
  </code></pre>
  
  <p>The above is in the class </p>
  
  <p>How can I fix my function that solve the Max Pool Size is Full on my server?</p>
  
  <p>Please Help me.</p>