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