Server Error in '/' Application.

The wait operation timed out

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.ComponentModel.Win32Exception: The wait operation timed out

Source Error:


Line 182:        sql += " where (BusinessName is not null ) and ( [country] like'%" + sLocation + "%' or [state] like'%" + sLocation + "%' or [District] like'%" + sLocation + "%' or [city] like'%" + sLocation + "%' or [location] like'%" + sLocation + "%') and CONTAINS((BusinessName,SubCategory,Keywords),'" + sCategoryName.Replace(" ","-") + "')  order by hlid desc";
Line 183:
Line 184:        if (conBusiness.State == ConnectionState.Closed) { conBusiness.Open(); }
Line 185:        SqlCommand com = new SqlCommand(sql, conBusiness);
Line 186:        SqlDataReader sdr = com.ExecuteReader();

Source File: c:\inetpub\vhosts\himachalsearch.com\httpdocs\App_Code\BusinessAndCategories.cs    Line: 184

Stack Trace:


[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)]
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +345
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +156
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +258
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413
   System.Data.SqlClient.SqlConnection.Open() +128
   clsBusinessAndCategories.fxnFeaturedBusiness(String sCategoryName, String sLocation, String sNo) in c:\inetpub\vhosts\himachalsearch.com\httpdocs\App_Code\BusinessAndCategories.cs:184
   MasterPage_Default.FeaturedBusiness(String sLoc) in c:\inetpub\vhosts\himachalsearch.com\httpdocs\OurModules\State\BusinessPage.aspx.cs:95
   MasterPage_Default.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\himachalsearch.com\httpdocs\OurModules\State\BusinessPage.aspx.cs:48
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3930.0