access数据库时常连接出错
如果使用频率不高,没有问题,但如果连续的连接,就会出现不能连接的问题
代码如下:
public static OleDbConnection con()
{
string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connstr"] + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["dbpath"]);
OleDbConnection connect = new OleDbConnection(strConnection);
return connect;
}
public static string sel(string i)
{
string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connstr"] + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["dbpath"]);
OleDbConnection connect = new OleDbConnection(strConnection);
connect.Open();
OleDbCommand command = new OleDbCommand(i, connect);
OleDbDataReader reader = command.ExecuteReader();
reader.Read();
return (reader[0].ToString());
connect.Close();
}
下面是web.config的代码
<appSettings>
<add key="connstr" value="Provider=Microsoft.Jet.OLEDB.4.0;Data source="/>
<add key="dbpath" value="~/database/cydb.mdb"/>
</appSettings>
出错的时候,抱错信息是在 connect.Open();高亮