PDA

View Full Version : Linux, UnixODBC and MDBTools



kettle_anonymous
12-12-2005, 06:47 AM
Hi,

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,
Ryan

MattCasters
12-12-2005, 07:07 AM
Ryan,

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,

Matt

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

kettle_anonymous
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.

Thanks,
Ryan

MattCasters
12-12-2005, 10:17 AM
Ryan,

Here is an encouraging message:

http://mail.easysoft.com/pipermail/unixodbc-support/2005-March/000444.html

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...

Cheers,

Matt