Connection pooling

I'm using C# & ASP.NET. When i create a loop/refresh page ... after 99 times i get

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. "

So my connection pool is full, but how can this be ?!  I created an empty page and only used these 2 code snippets. What am i doing wrong.

SqlDataAdapter oDataAdapter = new SqlDataAdapter("select * from users",
                                    "user id=sa;password=xxx;Initial Catalog=xxx;Data Source=(local)");
 
                              DataSet oDataSet = new DataSet();
                              oDataAdapter.Fill(oDataSet);
                              oDataAdapter.Dispose();
---------------------------------------------------
for(int i =0;i<105;i++)
                  {
                        using (SqlConnection oConn = new SqlConnection("user id=sa;password=xxx;Initial Catalog=xxx;Data Source=(local)"))
                        {
                              SqlCommand oCommand = new SqlCommand("select * from users");
                              oCommand.Connection = oConn;
                              oConn.Open();
                              try
                              {
                                    oCommand.ExecuteNonQuery();
                              }
                              finally
                              {
                                    oConn.Close();
                              }
                        }
                  }
LVL 4
zinnoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
CetusMODConnect With a Mentor Commented:
Question PAQ'd
250 points refunded.

CetusMOD
Community Support Moderator
0
 
zinnoAuthor Commented:
In my project settings, I had SQL Server debugging enabled. I turned that off and the problem went away.
0
All Courses

From novice to tech pro — start learning today.