Hi,

I think, to solve such problem you could adjust "SQL Server =
Properties->Query time-out" value using SQL Server Enterprise Manager or =
'sp_configure' system stored procedure. By default this value =3D 30 =
seconds.
Also, do not forget to set correct value for SqlCommand.CommandTimeout =
(again, the default value is 30 seconds).
--=20
Andrew Gnenny
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE


[quoted text, click to view]
Hi, All:

I have this error. It seems execution time is too long. Actually the =
execution time is about 30 seconds(I tested in Query analyzer). How do I =
solve this problem?

System.Web.Services.Protocols.SoapException: =
System.Web.Services.Protocols.SoapException: Server was unable to =
process request. ---> System.Data.SqlClient.SqlException: Timeout =
expired. The timeout period elapsed prior to completion of the =
operation or the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at =
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Com=
mandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 =
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, =
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 =
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, =
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String =
srcTable)
--- End of inner exception stack trace ---


Thanks,

Hi, All:

I have this error. It seems execution time is too long. Actually the =
execution time is about 30 seconds(I tested in Query analyzer). How do I =
solve this problem?

System.Web.Services.Protocols.SoapException: =
System.Web.Services.Protocols.SoapException: Server was unable to =
process request. ---> System.Data.SqlClient.SqlException: Timeout =
expired. The timeout period elapsed prior to completion of the =
operation or the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at =
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Com=
mandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 =
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, =
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 =
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, =
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String =
srcTable)
--- End of inner exception stack trace ---


Thanks,