程序里都是这样调用:
OleDbConnection MyConnection=new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]); Web.config:
<appSettings>
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\renke2\data_rk.mdb"></add>
</appSettings>
这样在本机上是没问题的!但传到服务器上就不行,因为这是绝对路径(G:\renke2\data_rk.mdb),怎样改Web.config变成相对路径.我用的是.net Framework 1.1,数据库是Access 2003,服务器是WIN 2003.请大家帮忙,不甚感激!!!
OleDbConnection MyConnection=new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]); Web.config:
<appSettings>
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\renke2\data_rk.mdb"></add>
</appSettings>
这样在本机上是没问题的!但传到服务器上就不行,因为这是绝对路径(G:\renke2\data_rk.mdb),怎样改Web.config变成相对路径.我用的是.net Framework 1.1,数据库是Access 2003,服务器是WIN 2003.请大家帮忙,不甚感激!!!
再用Server.MapPath将相对路径映射到完整的物理路径
<appSettings>
<add key="drives" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="database" value="/db/data.mdb" />
</appSettings>
</configuration>
Dim MyConnString As String = ConfigurationSettings.AppSettings("drives") + Server.MapPath(".") + ConfigurationSettings.AppSettings("database")
<add key="dbpath" value="data/sogo.mdb" />读时
string dbprovider = ConfigurationSettings.AppSettings["dbprovider"];
string dbpath;
string ConnectString;
OleDbConnection conn;
dbpath = Server.MapPath(ConfigurationSettings.AppSettings["dbpath"]);
ConnectString = dbprovider + "Data Source=" + dbpath;
conn = new OleDbConnection(ConnectString);
把数据库文件和应用程序放在同一个文件夹么。前面的不也省了么
用下试试。。
。