Ver Mensaje Individual
  #1 (permalink)  
Antiguo 22/11/2005, 02:03
Avatar de Jorgemen
Jorgemen
 
Fecha de Ingreso: mayo-2005
Ubicación: Perú
Mensajes: 322
Antigüedad: 19 años
Puntos: 1
Error timeout

Mi cadena de conexión es :
System.Text.StringBuilder sCadena=new System.Text.StringBuilder("");
sCadena.Append("data source=<SERVIDOR>;" );
sCadena.Append("database=<BASE>;" );
sCadena.Append("Persist Security Info=False;" );
sCadena.Append("Integrated Security=SSPI;" );
//sCadena.Append("Workstation id=PC1;");
//sCadena.Append("user id='Jorgemen_';packet size=4096");
sCadena.Replace("<SERVIDOR>", this.Servidor);
sCadena.Replace("<BASE>", this.Base);
return sCadena.ToString();




Como puedo solucionar este error que me sale cuando en mi interfaz que tengo botones hago que ejecute a las 6 pinchadas sucede esto como lo puedo solucionar??



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.


Source Error:

Line 75: }
Line 76: if(mConexion.State!=ConnectionState.Open)
Line 77: mConexion.Open();
Line 78: return mConexion;
Line 79: }


Source File: C:\Inetpub\wwwroot\FINAL\MATRICULA\DataAccess\Data Access.cs Line: 77

Stack Trace:

[InvalidOperationException: 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.]
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Matricula.DataAccess.DataAccess.get_Conexion() in C:\Inetpub\wwwroot\FINAL\MATRICULA\DataAccess\Data Access.cs:77
Matricula.DataAccess.DataAccessSQLServer.Comando(S tring ProcedimientoAlmacenado) in c:\inetpub\wwwroot\final\matricula\dataaccess\data accesssqlserver.cs:98
Matricula.DataAccess.DataAccessSQLServer.CrearData Adapter(String ProcedimientoAlmacenado, Object[] Args) in c:\inetpub\wwwroot\final\matricula\dataaccess\data accesssqlserver.cs:108
Matricula.DataAccess.DataAccess.TraerDataset(Strin g ProcedimientoAlmacenado, Object[] Args) in C:\Inetpub\wwwroot\FINAL\MATRICULA\DataAccess\Data Access.cs:107
Matricula.ReglasNegocio.Entidad.TraerFiltrado(Stri ng Filtro, Object[] Args) in C:\Inetpub\wwwroot\FINAL\MATRICULA\ReglasNegocio\E ntidad.cs:132
Matricula.ReglasNegocio.GestorCatalogo.HorasComple tas(Int32 idCatalogoAsignatura) in C:\Inetpub\wwwroot\FINAL\MATRICULA\ReglasNegocio\G estorCatalogo.cs:409
WebFormMatricula.IUMenuCatalgo.lbDias_SelectedInde xChanged(Object sender, EventArgs e) in c:\inetpub\wwwroot\final\matricula\webformmatricul a\iumenucatalogo.aspx.cs:416
System.Web.UI.WebControls.ListControl.OnSelectedIn dexChanged(EventArgs e)
System.Web.UI.WebControls.ListBox.System.Web.UI.IP ostBackDataHandler.RaisePostDataChangedEvent()
System.Web.UI.Page.RaiseChangedEvents()
System.Web.UI.Page.ProcessRequestMain()