This solution is work for me..

thanks a lot.

I'm having the same problem. i have already set "Connect Timeout=0"... and my query when running in query analyzer takes only 7 secs.. shouldn't that be fast enough? 

 pls help...

thanks..
 

Thanks the command timeout=0 did the trick!

I got the same error executing a complicated stored procedure from my VB.NET application.  However, rather than setting the command timeout = 0 which the documentation said is "not recommended," I just chose a longer interval of time.

MyCmd.CommantType = CommandType.StoredProcedure

MyCmd.CommandTimeout = 300              ' 5 minutes

MyCmd.ExecuteNonQuery

 This solved the problem. 

I am getting the same error too. The CommandTimeout is set to 30, which isn't probably a lot, but all I am doing is updating one record and then inserting 4 new records. It's being done with different SqlCommand and SqlConnection objects, so kinda unrelated. Two statements go one after another and take less then a second in Query Analyzer. What is strange is that if the update/insesrt fails in aplication and I will try exact same statement in Query Analyzer it may take 3-5 minutes to execute (different time every time), but once it's complete, and I try it again it takes less then a second. Also what is strange, it is absolutely inconsistent. It may complete ok one time (or even several) and then next time times out on update or finish update but fails the insert.

Any ideas. Please advise. Thanks.

HI,

I am facing the same problem.

My project is on .Net with SQL Server.

I am trying to retrieve a huge data at a time from DB. Previously it is working fine.

From three days back i am getting  "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

Even i made some changes to solve that

 in web.config i put "connect timeout = 300000" and

     CommandTimeout = 300000     (previously they are 10000)                         // 300000 = 5min

 still i am facing the same problem..

Can any one say solution for this

Regards,

Venkatesh 

I added the code below to the web.config file and it worked.  I found that there are two things that can time out.  The SQL call can time out and the application that is running can time out.

<system.web>
            <customErrors mode="Off"/>
            <httpRuntime appRequestQueueLimit="100" executionTimeout="60000" />
        </system.web>

Hopefully this works!

I am getting this error inside the preview data window when selected from the dataset. How or where to I change the timeout setting?

<add key="DBConnection" value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200"/>
 

This is working for me :) thank you.

set the command.connectiontimeout property to maximum integer value

it will solve the problem

'Sample code that has solved a similar problem for me:

Thanks every body the solutions were very helpfull

CmdGenCls.CommandTimeout = 300       worked for me

 Regards

Sara

thanks for your solution on command timeout=0 it works for me :-)

When I run my ASP.NET 2.0 web app on my dev machine it works perfect.

When I precomile it to my web deployment project and then copy the debug files to my web server I get this message in the middle . The Error is

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Error Stack : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, 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) at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames) at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames) at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String tableName) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DbCommand command) at DAL.OrderForms_DAL.GetTemplatesByTemplateID_DAL(Int32 OrgID, Int32 ClientId, Int32 TemplateID)

I changed the connection string to 120 I am tracing session time out also, But it was not worked for me.

I am getting this type of different errors every time, when i using the website. 

Please suggest me to find out the error? Thanks Advance