Time Out Error ..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

I was getting this error msg everytime I build and run the report..
sometimes I run fine sometimes it has error .. what should I do ?

"[SqlException: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
+45

System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
AAReport.PnrCountByAline.btExport_Click(Object sender, EventArgs e) in
C:\Travis\AAReport\AAReport\Go Holiday\frmPnrCountByAline.aspx.vb:67
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292"
 
Travis,

Whatever you are asking the db to do can't be accomplished before the
connection times out.

So you either need to make the db faster or reduce your demands on it.
Making it faster might mean indexing relevant fields or upgrading the
machine. Reducing the demand might mean returning less data at a time.

BugSentry needs beta testers!
www.bugsentry.com
 
Back
Top