topic Re: tAccess DB Connection issue While executing job in TAC in Talend Studio

tAccess DB Connection issue While executing job in TAC

sanjeevini — Sun, 24 Jun 2018 19:02:00 GMT

I have requirement to pull data from MS Access Db using the .accdb file.

I have installed the AccessDatabaseEngine_X64.exe and able to pull the data from Talend using tAccess Components locally , but when i am trying to execute the job using TAC , Job is failing with below errors.

Connection attempt to 'jdbcdbcriver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<xyz>.accdb' with the username ''.
java: symbol lookup error: /usr/java/jdk1.7.0_71/jre/lib/amd64/libJdbcOdbc.so: undefined symbol: SQLAllocEnv

Can anyone help me to solve this ? what all steps i have to carry out in server to install AccessDatabaseEngine_X64 and what all other setup i have to do.

Thanks
-Sanjeevini

Re: tAccess DB Connection issue While executing job in TAC

Anonymous — Mon, 25 Jun 2018 08:05:01 GMT

Hello,

Could you please indicate on which talend build version you got this issue?

Best regards

Sabrina

Re: tAccess DB Connection issue While executing job in TAC

sanjeevini — Mon, 25 Jun 2018 08:09:14 GMT

Hi Sabrina,

Its Talend Platform For Bigadata (5.6.1.20141207_1530).

Thanks

-Sanjeevini

Re: tAccess DB Connection issue While executing job in TAC

Anonymous — Fri, 29 Jun 2018 08:56:02 GMT

Hello,

The error is the result of libJdbcOdbc. What's OS are you using in your local? Did you connect to 32 bit Access in talend locally and deploy your job in 64 bit Linux TAC and Job server?

Best regards

Sabrina

Re: tAccess DB Connection issue While executing job in TAC

sanjeevini — Fri, 29 Jun 2018 09:05:21 GMT

Yes Sabrina. You are correct.

I have connect to 32 bit Access in talend locally(by installing MS access driver as i have 64bit OS ) and deployed job in 64 bit Linux TAC and Job server.

Let me know what all setups i need to make at Server level.

Thanks

-Sanjeevini

Re: tAccess DB Connection issue While executing job in TAC

Anonymous — Fri, 29 Jun 2018 09:09:24 GMT

Hello,

Would you mind creating a case on talend support portal so that we can give you a remote assistance(webex session) through support portal with priority?

Best regards

Sabrina

Re: tAccess DB Connection issue While executing job in TAC

sanjeevini — Fri, 07 Sep 2018 08:04:15 GMT

Hi ,

The issue solved by using tjdbc components with ucanaccess driver.

Thanks

-Sanjeevini