Progress OpenEdge dialect

Description

Currently NHibernate does not supply a dialect for Progress OpenEdge databases. As am involved in a project where we need one for OpenEdge 10.2A, I am currently porting this dialect from Hibernate / JDBC to NHibernate / ODBC.
I would like to submit it to SVN when I have finished testing it.

Environment

None

Attachments

02 Dec 2010, 12:06 AM

Activity

Show:

Jan Milter Ehlers November 11, 2013 at 7:40 PM

Some tips for this dialect:
Make sure SQL-access is enabled on the database
Create an SQL-user and give it access to the relevant tables
Install the OpenEdge ODBC-driver on you .net client machine
Test the ODBC connection - for example by installing Any Sql Maestro
Make sure you provide all details in the nHibernate connection configuration including database name, user (and password?) - even though you have already entered it in the driver.
We have only tested the dialect on OpenEdge 10.2x. I've heard that earlier versions had terrible SQL-support.

Oskar Berggren June 7, 2012 at 12:16 PM

Please consider testing it with current git master NHibernate, and submit a pull request.

Jan Milter Ehlers June 7, 2012 at 11:34 AM

My testing have ended, and we have been using this dialect in production for more than a year now without any issues, so it is ready for submission to the source code repository.