.net连接两种数据库的设置....

1.Access数据库

web.config文件:
<appSettings>
    <add key="DBPath" value="database/test.mdb" />
    <add key="Connection" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="/>
  </appSettings> 
test.aspx.cs文件:
        string strDBPath = System.Configuration.ConfigurationSettings.AppSettings["DBPath"];
        string strConn = System.Configuration.ConfigurationSettings.AppSettings["Connection"] + Server.MapPath(strDBPath);
        OleDbConnection myConnection = new OleDbConnection(strConn);

2.Sql Server数据库

web.config文件:
<appSettings>
    <add key="Conntction" value="server=localhost;uid=sa;pwd=system;database=test"/>
 </appSettings>
test.aspx.cs文件:
        string strConn = "server=localhost;uid=sa;pwd=system;database=test";
        SqlConnection myConnection = new SqlConnection(strConn);