您的位置:首页 > 博客中心 > 数据库 >

不同数据库下的web.config中数据库连接字符串

时间:2022-03-14 02:59

  <connectionStrings>

    <add name="OADBConnectionString" connectionString="Data Source=HONG-PC\SQL2005;Initial Catalog=OADB;User ID=sa;Password=123456" providerName="System.Data.SqlClient" />
    
    <add name="SqlServerConnectionString" connectionString="Data Source=127.0.0.1\sqlserver2008r2;Initial Catalog=Website;Integrated Security=False;User ID=sa;Password=Yk.888888;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False" providerName="System.Data.SqlClient"/>
    
    <add name="OledbConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\access.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
    
    <add name="OracleConnectionString" connectionString="DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=WebSite)));PASSWORD=a123456;PERSIST SECURITY INFO=True;USER ID=WebSiteDataDeveloper" providerName="Oracle.DataAccess.Client"/>
  
  </connectionStrings>

 

热门排行

今日推荐

热门手游