I have problem in sql with asp.net application

Posted by Nuwan under ASP.NET on 11/9/2012 | Points: 10 | Views : 893 | Status : [Member] | Replies : 2
Dear All,

I have get the error run asp.net application

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

Line 41:
Line 42: Dim sqlcon As SqlConnection = New SqlConnection(GetConnectionString)
Line 43: sqlcon.Open()
Line 44:
Line 45: Dim sqlcom As SqlCommand

Please hep me.



Posted by: Saratvaddilli on: 11/9/2012 [Member] [MVP] Bronze | Points: 25

i am not that much aware of this
but try these
fill your connection in between closing and opening of the connection

Thanks and Regards
Show difficulties that how difficult you are

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: M_Imranbest on: 11/10/2012 [Member] Starter | Points: 25

Try this one in web.config, may be it will resolve your problem.

<add name="conName" providerName="System.Data.SqlClient" connectionString="Data Source=MyPC;Initial Catalog=dbTest;Persist Security Info=True;User ID=test;Password=test;Connect Timeout=0 ;"/>

Thanks & Regards;
M Imran Ansari

Thanks & Regards;
Muhammad Imran Ansari

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response