Talend community forum / Connect to MS Access DB on Linux

Stefano · 2009-12-30 19:39:15

Tags: [access, database, driver, linux, odbc]

Hi to all,
I can't access to an mdb file on linux.
I've talend 3.2 and 4.0. My OS is Ubuntu 9.10.

When I try to configure the tAccessInput, I get this error when I try to retrieve the tables list:

java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$5.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
ERROR: java.lang.NullPointerException
ERROR: java.lang.NullPointerException
java.lang.RuntimeException: java.lang.NullPointerException
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.getConnection(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.returnTablesFormConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$5.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(Unknown Source)
... 4 more

There is a tutorial to connect an Access mdb in linux?
Thanks to all and happy new year!
Stefano

shong · 2009-12-31 07:33:12

Hello
You need install the odbc driver for linux machine.
Download access odbc driver for linux
http://www.easysoft.com/products/data_a … ess%20menu
Here is the getting started guide
http://www.easysoft.com/products/data_a … arted.html

I install access odbc driver on CentOS5.3 and use tDBInput to read records from a access data source, it works fine.

Best regards

shong

Bob Rachwal · 2011-02-08 17:08:57

I am using TIS Administrator to run jobs in UNIX.

I am also trying to populate access tables with this environment.

Will this driver work for this? Isn't there a free way to get this working other than the not free driver you mentioned?

Thanks for any help on this.

- Bob

Bob_Rachwal · 2011-02-08 17:16:06

Note: My post is referring to MS Access tables and how to get Administrator working.
- Bob

anselmo · 2011-09-20 00:44:45

Hi Shong, I followed your instructions and could connect to MS Access on Linux, the only problem was the charset, so I got ? instead of special chars.

Is there anyone experienced with this? Can I specify the charset on odbc.ini file?

Thanks a lot.

Announcement

Unanswered posts

#1 2009-12-30 19:39:15

Connect to MS Access DB on Linux

#2 2009-12-31 07:33:12

Re: Connect to MS Access DB on Linux

#3 2011-02-08 17:08:57

Re: Connect to MS Access DB on Linux

#4 2011-02-08 17:16:06

Re: Connect to MS Access DB on Linux

#5 2011-09-20 00:44:45

Re: Connect to MS Access DB on Linux

Board footer