Access 2010

[JMRB]

Hi folks,

I'm using version 3.1.0.4000.

Now I need to use an Access 2010 data base in a 64 bits computer.

Please can you provide me an example of nhibernate.cfg.xml?

Cheers

[Ricardo Peres]

You can use the ODBC driver, you just have to set up an ODBC data source.

[Michele Lepri]

Hello,
If you like to use the jet driver instead the odbc one, I'm using it in
one little project to test the jet database against sqllite and
firebird-embedded.

I'm using NHibernate 3.2 and the JetDriver recompiled with a fix:
http://groups.google.com/group/nhusers/browse_thread/thread/dac170338846670d/82256971503a8e9d?hl=en&lnk=gst&q=jet#82256971503a8e9d

Here is my xml configuration:
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property name="dialect">NHibernate.JetDriver.JetDialect,
NHibernate.JetDriver</property>
<property name="current_session_context_class">web</property>
</session-factory>
</hibernate-configuration>

You have to set the database path at runtime (or hardcode the full path
in xml, but in my case doesn't help).

Let us know if you have any problem

Cheers
michele

--
http://michelelepri.blogspot.com/

[Fabio Maulo]

Access is not a RDBMS