MS-Access JDBC Type 2 or 4 Driver

[tom62]

I have problems finding a JDBC type 2 or 4 freeware or open source driver for MS-Access. When "googling around" I only found commercial drivers, which license fees are outragiously expensive. I'm using currently the standard ODBC-JDBC bridge in my opensource project to read a 3rd party MS-Access database, but this type driver doesn't fulfill all my needs (f.e. it is not thread safe and I can't get it to read strings with non-latin texts). Does any one know an alternative driver that I can use for free?

 

[timw]

I've never found one. If none exists that would explain why these companies CAN charge large fees for their drivers.

Tim

 

[tom62]

I just wonder how difficult it would be to write one myself. Maybe I could "tweak" an existing opensource driver for (let's say) mySQL to accept M$ Access databases?

Tom

 

[timw]

If you could write your own Open Source Type 4 JDBC-ODBC bridge I'm sure it would be VERY popular. However, my instincts tell me that this would be a challenging undertaking. But don't let me put you off. If you think you have the necessary skills, go for it. This strikes me as a painfully obvious gap in the Java Open Source initiatives.

I'm not convinced that the MySQL source will help overly. For an MS Access solution, you'll either be coding to MS's proprietary interface into Access (ADO or DAO ??), or to ODBC API's (with a Bridge).

Tim

 

[tom62]

I think that it would take too much time and efforts to figure it all out by myself. I also fear that the challence lies beyond my technical skill-level.

Tom