>Hello Guys
>
>I have the following problem, everytime i try to execute a store procedure I get the following error:
>
>Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
>
>Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
>
>Source Error:
>
>
>Line 179:
>Line 180: ' Fill DataTable
>Line 181: mySqlDataAdapter.Fill(myDataset, "zip5")
>Line 182:
>Line 183: ' Close Connection
>
>
>Source File: c:\inetpub\wwwroot\Testing\DB.vb Line: 181
>
>Stack Trace:
>
>
>[SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> System.Data.SqlClient.TdsParser.ReadBuffer()
> System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32 offset, Int32 len)
> System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length, Encoding encoding)
> System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32 length)
> System.Data.SqlClient.SqlDataReader.SeqRead(Int32 i, Boolean useSQLTypes, Boolean byteAccess, Boolean& isNull)
> System.Data.SqlClient.SqlDataReader.SeqRead(Int32 i, Boolean useSQLTypes, Boolean byteAccess)
> System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
> System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues, Boolean acceptChanges)
> System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping)
> System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
> System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
> Testing.DB.get5zip(String lat, String lng, Int32 radius) in c:\inetpub\wwwroot\Testing\DB.vb:181
> Testing.physiciansearchresult.process5zip() in c:\inetpub\wwwroot\Testing\physiciansearchresult.aspx.vb:104
> Testing.physiciansearchresult.processscopes() in c:\inetpub\wwwroot\Testing\physiciansearchresult.aspx.vb:58
> Testing.physiciansearchresult.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\Testing\physiciansearchresult.aspx.vb:44
> System.Web.UI.Control.OnLoad(EventArgs e)
> System.Web.UI.Control.LoadRecursive()
> System.Web.UI.Page.ProcessRequestMain()
>
>
>
>
>--------------------------------------------------------------------------------
>Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
>
>I have changed the connection timeout to 10 minutes, and the machine configuration to infinite and still times out, does any body have any suggestions:
>
>Greatly appreciated
>
>
>Mario Martinez

Mario,

There is also a timeout associated with the individual query. The default is 30 seconds. See SqlCommand.CommandTimeOut for more info.