We're switching over to use ConfigurationSectionHandler (switching from NameValueSectionHandler) in our App.config and BuildSessionFactory returns an error, "The hibernate.connection.driver_class must be specified in the NHibernate configuration section.", despite the fact that we have this. Note also that in our old way when using NameValueSectionHandler, we didn't have to specify hibernate.connection.driver_class. Any ideas on what we're doing wrong?

Here's the simple code snippet:
NHibernate.Cfg.Configuration cfg = new NHibernateConfiguration();
ISessionFactory sf = cfg.BuildSessionFactory();


Pertinent parts of App.config:
<configSections>
<section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler,NHibernate" />
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" requirePermission="false"/>
</configSections>

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.dialect">NHibernate.Dialect.MsSql2000Dialect</property>
<property name="hibernate.connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="hibernate.connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="hibernate.connection.connection_string">Server=localhost;initial catalog=CHNOPSDb;Integrated Security=SSPI</property>
<property name="hibernate.bytecode.provider">null</property>
<property name="hibernate.current_session_context_class">managed_web</property>
<property name="hibernate.max_fetch_depth">4</property>
</session-factory>
</hibernate-configuration>


NOTE: The following worked but I'm trying to get the above to work now --

<configSections>
<section name="nhibernate" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" requirePermission="false"/>
</configSections>

<nhibernate>
<add key="hibernate.show_sql" value="true"/>
<add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
<add key="hibernate.connection.connection_string" value="Server=localhost;initial catalog=CHNOPSDb;Integrated Security=SSPI"/>
<add key="hibernate.bytecode.provider" value="null"/>
<add key="hibernate.current_session_context_class" value="managed_web"/>
<add key="hibernate.max_fetch_depth" value="4"/>
</nhibernate>

I'm not sure if that's the problem, but as I can remember, you don't need the hibernate prefix, when you use this configuration style:

Thanks, Wolfgang -- I did try to remove the prefix and received the same error :( ...

Is it possible that your App.config is flagged as "Embedded Resource" ? I just found out, that that isn't working. You have to set build action to "None".

Thanks again -- unfortunately, App.config is not embedded -- I appreciate the suggestions!

You're using 1.2, right ? I was curious and digged through the docs again and found this in chapter 3.5 of the reference documentation:



Followed by a list of the relevant options, including dialect. According to this, I would say, your approach will not work :-(. I think the behaviour is different with 2.0, where this should be possible.

Thanks, again -- Yes, we're using a custom-built version that's not 2.0 (we needed a special fix). Thanks very much -- you solved it :)