View Full Version : Linux, UnixODBC and MDBTools

12-12-2005, 06:47 AM

We need to connect to a MS Access database from a Linux platform.
I've installed UnixODBC and MDBTools and tested the setup to make sure I can connect to the database and it all works fine. What I am having problems with though, is connecting to the ODBC source from Spoon.

Is it possible to connect to a UnixODBC database using Spoon, and if so can anyone give me some pointers?

The error message that spoon is kicking out is 'Error occured while trying to connect to the database'

Many thanks,

12-12-2005, 07:07 AM

ODBC is supported through the jdbc2odbc bridge from the Java VM (from Sun).
This is a pure java implementation and I doubt this will work with unixODBC.

I can't find a reference for Linux on http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/bridge.doc.html

Perhaps there is a UnixODBC to java bridge available somewhere that we can implement?

Good luck,


P.S. Why not transfer the data from the windows platform to a MySQL database on Linux?

12-12-2005, 07:25 AM
Hi Matt,

Thanks for the quick reply.

The access database is part of a production system so unfortunately we can't move it.
What we want to do is to be able to do periodic transfers of the data to MySQL so we can use the data for reporting etc.

I'll have a look for a UnixODBC to java bridge and see if that turns up anything.


12-12-2005, 10:17 AM

Here is an encouraging message:


Unfortunately, the required JDBC-ODBC bridge is not free but sold by "easysoft" (!) for US$999.00.
Note: that's more then the SAP client for Kettle :-((

Mmm, keep looking. Then again, if the free trial works for you and you want to pay the price...