Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with MsAccess connexion

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 ).
Labels (4)
2 Replies
Anonymous
Not applicable
Author

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

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.