N2cms的连接字符串

SQL Server 2005

<connectionStrings>
<add name="N2CMS" connectionString="Server=(local);Database=DATABASENAME;Integrated Security=SSPI"/>

<n2><database connectionStringName="N2CMS" flavour="SqlServer2005" />

SQL Server 2005 Express Instance

<connectionStrings>
<add name="N2CMS" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\N2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

<n2><database connectionStringName="N2CMS" flavour="SqlServer2005" />  

MySQL

<connectionStrings>
<add name="N2CMS" connectionString="Data Source=MySQLServer;Database=MySQLDatabase;User Id=MySQLUser;Password=MySQLPassword;" providerName="MySql.Data.MySqlClient"/>

<n2><database connectionStringName="N2CMS" flavour="MySql" />

SQLite

Please not that the SQLite driver does not work in medium trust.

<connectionStrings>
<add name="N2CMS" connectionString="Data Source=|DataDirectory|\n2.db;Version=3;New=True;" providerName="System.Data.SQLite"/>

<n2><database connectionStringName="N2CMS" flavour="SqLite" />