常用数据库连接字符串
编辑: EKETEAM 最后编辑时间: 2025-05-09 23:48 浏览: 25
常用数据库连接字符串：
1.SQLServer
<add name="SQLServer" connectionString="Data Source=数据库IP地址,端口;Initial Catalog=数据库名;User Id=数据库用户;Password=数据库密码;" providerName="System.Data.SqlClient"/>
2.Oracle
<add name="Oracle" connectionString="Data Source=127.0.0.1/ORCL;User ID=数据库用户;Password=数据库密码;" providerName="Oracle.ManagedDataAccess.Client"/>
3.MySQL
<add name="MySQL" connectionString="Server=localhost;PORT=3306;Database=数据库名;UID=数据库用户;Pwd=数据库密码;charset=utf8;UseAffectedRows=True;Allow Zero Datetime=True;" providerName="MySql.Data.MySqlClient"/>
<add name="MySQLOdbc" connectionString="Driver={MySQL ODBC 5.3 ANSI Driver};Server=.;PORT=3306;Database=eFrameWork;User=root;Password=123456;Option=3;UseAffectedRows=True;" providerName="System.Data.Odbc" />
4.SQLite
<add name="SQLite" connectionString="Data Source=|DataDirectory|\ekecms.db;Version=3;Synchronous=off;" providerName="System.Data.SQLite"/>
5.Access
<add name="Access" connectionString="Provider=Microsoft.jet.OLEDB.4.0;Data Source=|DataDirectory|\Access.mdb;" providerName="System.Data.OleDb"/>
<add name="Access2" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\AccDB.accdb;" providerName="System.Data.OleDb" />
6.Excel
<add name="Excel" connectionString="Provider=Microsoft.jet.OLEDB.4.0;Data Source=|DataDirectory|\Excel.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=0;'" providerName="System.Data.OleDb" />
<add name="Excel2" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Excel2.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=0;'" providerName="System.Data.OleDb" />
7.SqlServerCe
<add name="SqlServerCe" connectionString="Data Source=|DataDirectory|\SqlServerCe.sdf" providerName="System.Data.SqlServerCe.4.0"/>
热词：低代码网站WebAPI发布