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();
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;
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

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

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

From novice to tech pro — start learning today.