Use Hibernate with SQL Server Expresss ?

nesaver · **Joined:** Sat Sep 22, 2007 12:22 pm **Posts:** 2

I want to use hibernate with attached database in C# project. But, with my hibernate.xml, it throw an Persistence Exception :

Code:

<hibernate-configuration  xmlns="urn:nhibernate-configuration-2.0" >
   <session-factory name="localfactory">
      <!-- properties -->
      <property name="hibernate.connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="hibernate.dialect">NHibernate.Dialect.MsSql7Dialect</property>
      <property name="hibernate.connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
      <property name="hibernate.connection.connection_string">Data Source=.\\SQLEXPRESS;Database = Sample;Integrated Security=True;User Instance=True</property>
      <property name="show_sql">false</property>
      
      <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
      <!-- mapping files -->
      <mapping assembly="QT.Demo" />
   </session-factory>
</hibernate-configuration>

Can you help me ?

karlchu · **Posted:** Sat Sep 22, 2007 6:43 pm

Please post at least the exception message, if not the full stack trace.

Off the top, the schema version should be 2.2 (assuming you are using NHibernate 1.2GA):

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >

nesaver · **Joined:** Sat Sep 22, 2007 12:22 pm **Posts:** 2

It run well when

Code:

<property name="hibernate.connection.connection_string">Server=localhost,1433;Database=Sample;User ID=sa;Password=$a</property>

but , I want use an attached database.

What connection string can I use ?

karlchu · **Posted:** Sun Sep 23, 2007 12:37 am

See here:
http://www.connectionstrings.com/?carrier=sqlserver2005