Help Questions | Solutions | Experts

Select Categories Below

.net [

]

Bluetooth [

]

browsers [

]

C# [

]

computer [

]

Errors [

]

forms [

]

HTML [

]

information tec... [

]

internet [

]

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

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 Databases
Access .net
NHibernate

Answer Discussion

Tutorials

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 a Tutorial in the Tutorial 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 tutorials have been submitted yet. Want to be the first?