Error while connecting to MS Access data

[dvarshav]

Hi,
I need to bring MS Access data into my Knime workflow. I used Microsoft Access Connector node but got this error message:
“Execute failed: UCAExc:::4.0.4 Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.”
Any advice would be appreciated
Thanks,
Denis

[nagarjun36]

Hi @dvarshav ,

Welcome to KNIME Community.

There were couple of similar errors in the past and I have pasted some of them below, Let us if the provided information helped you to resolve your issue.

How to connect to MS Access Database

Hi, here are the steps you need to perform to connect to a MS Access database with KNIME Analytics Platform: Download the UCanAccess JDBC driver by clicking on this link Extract the downloaded zip file to a folder on your local hard drive Create a new folder e.g. UCanAccess on your hard drive Copy from the extracted folder the following files into the new created folder (see driverFiles.PNG): ucanaccess-4.0.3.jar (located in the root folder) commons-lang-2.6.jar (located in the lib…

MS Access password protected

Hello, i’m new to Knime and the forum. I hope you can help me with an access-issue in Knime. I created a workflow to open and read a database by Microsoft Access Connector Node and it worked perfectly. But how to open a password protected access database? I try to use the Credentials Configuration node and found out here in the forum i have to add a jdbc parameter in the MS Access Connector. I get the following Error: Execute failed: UCAExc:::4.0.4 Decoding not supported. Please choose a Cod…

Regards,
Nagarjun S

[dvarshav]

Thank you, I appreciate the quick response.
I ended up importing MS Access db into SQL server and then using SQL connector node in Knime.
Thanks,
Denis Varshavsky