dhis2-devs team mailing list archive

Thread
Date

Re: DHIS 2

To: "Robinson, Ed" <ERobinson@xxxxxxxxxxxxxxxx>
From: Knut Staring <knutst@xxxxxxxxx>
Date: Wed, 24 Mar 2010 17:57:23 +0100
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <1245E5B0A7CCB74089CE584F428F3F23305E8E30@FGIMBXT.futuresgroup.com>

On Wed, Mar 24, 2010 at 1:02 PM, Robinson, Ed <ERobinson@xxxxxxxxxxxxxxxx>wrote:

> Thanks a lot for your input Knut.  Do you recommend any third party gui to
> work with H2 databases?

Good question, Ed. I'm copying this to the list. An expanded version should
be included in the DHIS2 documentation:

There are several options for GUI clients to manage H2 databases. H2 itself
comes with a nice web interface which is quite capable. Otherwise, it is
supposed to support the Postgresql ODBC driver
http://www.theserverside.com/news/thread.tss?thread_id=46456. This should
allow the use of MS Access as front end, which I tried to do something with
that some time back, but ran into some problems (cannot recall exactly).

An alternative is  to use the JDBC driver and connect to one of several
clients. Two that we have used are NetBeans or OpenOffice (similar to
Access):
http://www.oooforum.org/forum/viewtopic.phtml?t=97522

Knut