数据库连接字符串

<Connections>
    <Connection id="testMdb"
                class="System.Data.OleDb.OleDbConnection"
                adapter="System.Data.OleDb.OleDbDataAdapter"
                connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\Query\test.mdb;User Id=admin;Password="
               />

    <Connection id="Calendar"
                class="System.Data.OleDb.OleDbConnection"
                adapter="System.Data.OleDb.OleDbDataAdapter"
                connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\Query\calendar.mdb;User Id=admin;Password="
               />              

    <Connection id="SampleSqlServer"
                class="System.Data.SqlClient.SqlConnection"
                adapter="System.Data.SqlClient.SqlDataAdapter"
                connectionString="Data source=(local);Initial Catalog=MyDatabase;Integrated Security=SSPI;"
               />

    <Connection id="SampleOracleOle"
                assembly="System.Data"
                class="System.Data.OleDb.OleDbConnection"
                adapter="System.Data.OleDb.OleDbDataAdapter"
                connectionString="Provider=msdaora;Server=MyServer;User Id=MyUserID;Password=MyPassword"
               />              

    <Connection id="SampleOracle"
                assembly="System.Data.OracleClient"
                class="System.Data.OracleClient.OracleConnection"
                adapter="System.Data.OracleClient.OracleDataAdapter"
                connectionString="Data Source=OracleDB; User Id=user;Password=pass"
               />               
               
    <Connection id="NorthwindSQL"
                class="System.Data.SqlClient.SqlConnection"
                adapter="System.Data.SqlClient.SqlDataAdapter"
                connectionString="Data source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;"
               />

</Connections>

转载于:https://www.cnblogs.com/jinglelin/archive/2004/09/04/39733.html