Using Microsoft Access with Java without the JdbcOdbc default bridge

views:

124

answers:

Using Microsoft Access with Java without the JdbcOdbc default bridge

Hi,

we have to use in our project some legacy Microsoft Access 97/2000 databases with Java. The problem is: we face many problems with the default JdbcOdbc driver which is available on the JDK (memory leaks are the most common issue).

So here is my question: is there any other JDBC Driver we could use (open source whould be great) to achieve this task?

This seems to be the alternative: http://www.csv-jdbc.com/stels_mdb_jdbc.htm

OscarRyz 2009-11-19 15:24:32

Thanks for that link! But - isn't that driver limited to MS Excel?

Andreas_D 2009-11-19 15:27:07

Do'h! my bad :)

OscarRyz 2009-11-19 15:27:33

@Andreas: I have fixed the link, thanks :)

OscarRyz 2009-11-19 15:30:53

Actually this is ALMOST what I need. This driver does not work with Access 97 :(

Henrique Lobo Weissmann 2009-11-19 15:32:38

Ouch... almost :( You may try contacting them and see if such a thing is feasible.

OscarRyz 2009-11-19 15:58:23

+1 A:

HXTT and StelsMDB seems to be the most "famous" providers of type 4 JDBC driver for MS Access. The first one supports version from 95, 97, 2000, XP, 2002, to 2003 (and thus meets your requirements). The other one supports MS Access 2000, 2002, 2003, XP.

Easysoft is another alternative but is a JDBC type 3 driver (i.e. a bridge type).

All are commercial products.

Pascal Thivent 2009-11-19 16:17:02

+1 for reminding of HXTT. I knew there was one, but didn't recall anymore.

BalusC 2009-11-19 16:47:22

ansaurus

tags:

views:

answers:

Using Microsoft Access with Java without the JdbcOdbc default bridge

related questions