在页面中的连接串为:
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""D:\database\mydb.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
程序能正常运行,现在放到web.config中为:
<appSettings>
<add Key="CString" Value=@"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""D:/database/mydb.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False" />
</appSettings>
运行后出错说:
An error occurred loading a configuration file: 文件 'D:\wwwroot\****\web.config' 中元素 '<appSettings>' 附近的 XML 无效。看了看,想是数据库名字和数据库驱动名前后都有两件双引号,是不是这个问题,怎么写才行呢?
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""D:\database\mydb.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
程序能正常运行,现在放到web.config中为:
<appSettings>
<add Key="CString" Value=@"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""D:/database/mydb.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False" />
</appSettings>
运行后出错说:
An error occurred loading a configuration file: 文件 'D:\wwwroot\****\web.config' 中元素 '<appSettings>' 附近的 XML 无效。看了看,想是数据库名字和数据库驱动名前后都有两件双引号,是不是这个问题,怎么写才行呢?
<add key="ConnectionString" value="provider=microsoft.jet.oledb.4.0; datasource=数据源; user id=用户名;password=密码;"></add>
</appsettings>
zhangxiaopin的方法应该没问题,但是不是要配一下数据源呢?不能直接用字串完成吗?
另外,web.config中记录access地址即可,没必要那么复杂。
简单一点
如果你的数据库在当前web应用程序的database文件夹中,你可以这样在web.config中设置数据库路径:
<appSettings>
<add key="ConnectionString" value="~/database/mydb.mdb"/>
</appSettings>