超时时间已到。在从池中获取连接之前超时时间已过。出现这种情况可能是因为所有池连接都已被使用并已达到最大池大小。WebService 数据库是SQL Server在构造函数中初始化数据库连接#region 构造函数public MonitorService()
{
//CODEGEN: 该调用是 ASP.NET Web 服务设计器所必需的
InitializeComponent(); string m_strConnectionString = ""; m_strConnectionString = m_strConnectionString + "Data Source=" + System.Configuration.ConfigurationSettings.AppSettings["DataSource"] + ";";
m_strConnectionString = m_strConnectionString + "Initial Catalog=" + System.Configuration.ConfigurationSettings.AppSettings["InitialCatalog"] + ";";
m_strConnectionString = m_strConnectionString + "User Id=" + System.Configuration.ConfigurationSettings.AppSettings["UserId"] + ";";
m_strConnectionString = m_strConnectionString + "Password=" + System.Configuration.ConfigurationSettings.AppSettings["Password"] + ";"; CS = new SqlConnection(m_strConnectionString);
}
#endregion
然后在每一个[WebMethod]中采用CS.Open();
打开数据库连接
{
//CODEGEN: 该调用是 ASP.NET Web 服务设计器所必需的
InitializeComponent(); string m_strConnectionString = ""; m_strConnectionString = m_strConnectionString + "Data Source=" + System.Configuration.ConfigurationSettings.AppSettings["DataSource"] + ";";
m_strConnectionString = m_strConnectionString + "Initial Catalog=" + System.Configuration.ConfigurationSettings.AppSettings["InitialCatalog"] + ";";
m_strConnectionString = m_strConnectionString + "User Id=" + System.Configuration.ConfigurationSettings.AppSettings["UserId"] + ";";
m_strConnectionString = m_strConnectionString + "Password=" + System.Configuration.ConfigurationSettings.AppSettings["Password"] + ";"; CS = new SqlConnection(m_strConnectionString);
}
#endregion
然后在每一个[WebMethod]中采用CS.Open();
打开数据库连接
还有看看程序其他地方打开连接释放没有阿?