Connection strings

UPDATE: The "Test Connection" feature in version 1.2.5 doesn't work. You can ignore this step and try installing the database directly.

SQL Server 2005

    <!-- Extract of a configuration using SQL Server 2005 ... -->
    <connectionStrings>
        <clear/>
        <add name="LocalSqlServer" connectionString="Server=SERVERNAME;Database=DATABASENAME;User Id=LOGINNAME;Password=PASSWORD;Network Library=DBMSSOCN;"/>
    </connectionStrings>

  <castle>
    <properties>
      <!--...-->
      <nhSettings>
        <dictionary>
        <!--...-->
          <entry key="hibernate.connection.driver_class">NHibernate.Driver.SqlClientDriver</entry>
          <entry key="hibernate.dialect">NHibernate.Dialect.MsSql2005Dialect</entry>
          <!--...-->

SQL Server 2000

    <!-- Extract of a configuration using SQL Server 2000 ... -->
    <connectionStrings>
        <clear/>
        <add name="LocalSqlServer" connectionString="Data Source=SQLServer2000;Database=SQLDatabase2000;User Id=SqlUser2000;Password=SqlPassword2000;Network Library=DBMSSOCN;" providerName="System.Data.SqlClient"/>
    </connectionStrings>

  <castle>
    <properties>
      <!--...-->
      <nhSettings>
        <dictionary>
        <!--...-->
              <entry key="hibernate.connection.driver_class">NHibernate.Driver.SqlClientDriver</entry>
              <entry key="hibernate.dialect">NHibernate.Dialect.MsSql2000Dialect</entry>
          <!--...-->

SQL Server 2005 Express

    <!-- Extract of a configuration using SQL Server 2005 Express ... -->
    <connectionStrings>
        <clear/>
        <add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\N2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>    </connectionStrings>

  <castle>
    <properties>
      <!--...-->
      <nhSettings>
        <dictionary>
        <!--...-->
          <entry key="hibernate.connection.driver_class">NHibernate.Driver.SqlClientDriver</entry>
          <entry key="hibernate.dialect">NHibernate.Dialect.MsSql2005Dialect</entry>
          <!--...-->

MySQL

    <!-- Extract of a configuration using MySQL (also requires an ado.net driver) -->
    <connectionStrings>
        <clear/>
        <add name="LocalSqlServer" connectionString="Data Source=MySQLServer;Database=MySQLDatabase;User Id=MySQLUser;Password=MySQLPassword;" providerName="MySql.Data.MySqlClient"/>
    </connectionStrings>

  <castle>
    <properties>
      <!--...-->
      <nhSettings>
        <dictionary>
        <!--...-->
              <entry key="hibernate.connection.driver_class">NHibernate.Driver.MySqlDataDriver</entry>
              <entry key="hibernate.dialect">NHibernate.Dialect.MySQL5Dialect</entry>
          <!--...-->

SQLite

    <!-- Extract of a configuration using MySQL (ado.net driver) -->
    <connectionStrings>
        <clear/>
        <add name="LocalSqlServer" connectionString="Data Source=MySQLServer;Database=MySQLDatabase;User Id=MySQLUser;Password=MySQLPassword;" providerName="MySql.Data.MySqlClient"/>
    </connectionStrings>

  <castle>
    <properties>
      <!--...-->
      <nhSettings>
        <dictionary>
        <!--...-->
               <entry key="hibernate.connection.driver_class">NHibernate.Driver.SQLite20Driver</entry>
              <entry key="hibernate.dialect">NHibernate.Dialect.SQLiteDialect</entry>
         <!--...-->