常用数据库连接集合

  <configuration>
    <appSettings/>
    <connectionStrings>
      <clear/>
      <add name="AdventureWorksString"
      providerName="System.Data.SqlClient"
      connectionString="Data Source=localhost;Initial Catalog=AdventureWorks; Integrated Security=true"/>
      <add name="MarsEnabledSqlServer2005String"
      providerName="System.Data.SqlClient"
      connectionString="Server=Aron1;Database=pubs;Trusted_Connection=True;MultipleActiveResultSets=true" />
      <add name="OdbcConnectionString"
      providerName="System.Data.Odbc"
      connectionString="Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"/>
      <add name="AccessConnectionString"
      providerName="System.Data.OleDb"
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" />
      <add name="OracleConnectionString"
      providerName="System.Data.OracleClient"
      connectionString="Data Source=MyOracleDB;Integrated Security=yes;" />
    </connectionStrings>
    <system.web>
      <!-- -->
      <compilation debug="true"/>
      <!-- -->
      <authentication mode="Windows"/>
      <!-- -->
    </system.web>
  </configuration>