Questions | Solutions | Experts

Select Categories Below

.net [

]

asp.net [

]

browsers [

]

C# [

]

CSS [

]

Databases [

]

email [

]

Errors [

]

HTML [

]

information tec... [

]

Question

Status: Closed Points: 25 Time: 04:50 - Feb 13, 2007

theDude

How do I connect to an ms access database with NHibernate?

I need to connect to an ms access 2003 database instead of the usual ms sql server.
How do I do that?

Categories:

sql programming
Access Databases
NHibernate .net

Answer Discussion

Answer Summaries

Q&A System for Websites and Corporate Collaboration

Generates significant organic traffic for websites
Saves companies money, resources, and time

theDude

Date:: Mar 23, 2007

Time:: 15:30

i found that to do that, i had to get the special jetdriver for nhibernate (in the nhibernate contributions package) and these are the provider settings for the app/web.config file
<nhibernate>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

<add key="hibernate.dialect" value="NHibernate.JetDriver.JetDialect,NHibernate.JetDriver" />

<add key="hibernate.connection.driver_class" value="NHibernate.JetDriver.JetDriver,NHibernate.JetDriver" />

<add key="hibernate.connection.connection_string" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb" />
</nhibernate>

Question Answered

This question has been closed, and points have been rewarded to the following experts:

theDude:

You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for the Summary Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No summaries have been submitted yet. Want to be the first?