Timeout expired. The timeout period elapsed prior to obtaining a connection from the

bootsy

I get a timeout error using the code below. The Utils.GetDataTableForUI is calling a stored procedure(dbo.ConferencesSEL. The stored procedure does a simple select statement. Can someone tell me what I need to do to eliminate the timeout error on the page. Here is the code.

Expand|Select|Wrap|Line Numbers

 using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Text;
 
namespace HSI

{

    public partial class ofinterest_conferences : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            LoadConferences();

        }
 
        private void LoadConferences()

        {

            StringBuilder sb = new StringBuilder();

            DataTable dt = Utils.GetDataTableForUI("dbo.ConferencesSEL", null);
 
            foreach (DataRow dr in dt.Rows)

            {

                sb.Append("<div class=\"infoContainer\">");

                sb.Append("   <p>");

                sb.Append("      <strong>" + dr["event_date"].ToString() +" : " + dr["title"].ToString() + " </strong><br />");

                sb.Append("      " + dr["location"].ToString());

                sb.Append("   </p>");

                sb.Append("   <p class=\"moreInfoWrap\">");
 
                string urlPDF = string.Empty;

                if (!String.IsNullOrEmpty(dr["pdf_path"].ToString()))

                {

                    urlPDF = (string)ConfigurationManager.AppSettings["pdfUploadPath"].ToString() + dr["pdf_path"].ToString();

                }

                else if (!String.IsNullOrEmpty(dr["url"].ToString()))

                {

                    urlPDF = dr["url"].ToString();

                }
 
                sb.Append("      <a href=\"" + urlPDF + "\" target=\"_blank\" class=\"moreInfo\">WANT MORE INFO</a>");

                sb.Append("   </p>");

                sb.Append("</div>");

            }
 
            this.confContainer.InnerHtml = sb.ToString();

        }

    }

}

Plater

Well your error message is cutoff in the title of your post (please remember to put the error message in the body of your post as well)

But it looks like it is timing out trying to connect to your database.
Check your connection string and verify that your program has the correct credentials/permissions to connect to the database, and that it is not blocked by any firewalls or anything

bootsy

Here it is:

Expand|Select|Wrap|Line Numbers

 using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Web.UI;

namespace HSI 

{

  public class Utils : Page

  {

    public Utils();

Plater

What is that ?

bootsy

Quote:

Originally Posted by Plater

What is that ?

That's the connection string to the Utils functiion

Plater

Quote:

Originally Posted by bootsy

That's the connection string to the Utils functiion

There is no connection string in that code. All you posted was your using statements

bootsy

Quote:

Originally Posted by Plater

There is no connection string in that code. All you posted was your using statements

Sorry I forgot to post the rest of the code

Also this:

Expand|Select|Wrap|Line Numbers

 public static DataTable GetDataTableForUI(string sproc, List<SqlParameter> sps) 

{
 
SqlConnection conn = new SqlConnection((string)ConfigurationSettings.AppSettings["DBConnectionString"]); 

conn.Open();
 
SqlCommand comm = new SqlCommand(sproc, conn); 

comm.CommandType = CommandType.StoredProcedure;
 
if (sps != null) 

{
 
for (int i = 0; i < sps.Count; i++) 

{
 
comm.Parameters.Add(sps[i]);
 
}
 
}
 
SqlDataAdapter da = new SqlDataAdapter(comm);DataTable dt = new DataTable(); 

da.Fill(dt);
 
return dt;
 
}

Plater

Well that still doesn't include your connection string, because its referencing one stored in your web.config file.

Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

re: Timeout expired. The timeout period elapsed prior to obtaining a connection from the

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about