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 CodecProvider which supports reading the current database encoding
can you tell me, what i need to get the password protected database read?
The Credentials Configuration node is just an interface to enter credentials that you can then use as a flow variable as dynamic values. But if the node you are capturing the credentials for, in your case the MS Access Connector, does not support credentials, you will not be able to pass the credentials, and the MS Access Connector does not support credentials.
Can you try with the DB Connector instead and see if it works? There you can pass credentials.
You can actually pass the password as a JDBC Parameter, like this:
However, this works only for MS Access files that are password protected without encryption, that is mdb files. This does not seem to work for accdb files as accdb files that are password protected are encrypted.
I’ve tried various ways, even using the UCanAccess driver and also passing the password via the connection string for the accdb file, it does not work.