topic Problem with MsAccess connexion in Talend Studio

Problem with MsAccess connexion

Anonymous — Sat, 16 Nov 2024 10:24:18 GMT

Hi everyone,
I'am trying to connect my Ms access DataBase to Talend, i had this issue :
Caused by : net.ucanaccess.jdbc.UcanaccessSQLException : Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.
I guess that this is an issue about the 64bit ODBC ? how can i fixe that ? or how can i install the new drives ?
FYI : i can't switch my pc to 32bits.
My configuration :
- Win8 64Bits.
- Talend Studio 6.2.1 64bit.
- Ms-Access 2013 (.accdb ).

Re: Problem with MsAccess connexion

Anonymous — Fri, 09 Sep 2016 08:51:06 GMT

Hi,
Can you connect to your Access successfully through client without using Talend tool?
Best regards
Sabrina

Re: Problem with MsAccess connexion

Anonymous — Fri, 09 Sep 2016 14:43:20 GMT

Hi guys,
the Access database is likely encrypted and password protected, yet it's possible (and simple) the integration between UCanAccess and Talend for these cases too.
You will have to add some more jar and configure UCanAccess/Jackcess to read encrypted db. Nothing difficult.
I'm Marco Amadei and I'm both a Talend user and the UCanAccess author, so should you(Talend team) need an helping hand, please let me know.