Access database encoding
Answered
Hello
I am trying to create an acceee database as a data source, in accdb format I use ucanaccess, as specified in this post:
However, I get the following error when trying to connect: com.healthmarketscience.jackcess.impl.UnsupportedCodecException: Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding
Regards!
The same question
Hi Daniel,
Thank you for reaching out to us on this. Based on the error which is coming directly from the JDBC driver, it suggests that this database is encrypted. The following comes directly from the UCanAccess site (https://jackcess.sourceforge.io/faq.html#encoding)
Having looked into the encryption provider I am not sure this will be able to be added without creating your own jdbc extension, so I would recommend removing the password from the Access database file and testing again to see if this works.Cheers,
Neal
Hi Daniel,
Thank you for reaching out to us on this. Based on the error which is coming directly from the JDBC driver, it suggests that this database is encrypted. The following comes directly from the UCanAccess site (https://jackcess.sourceforge.io/faq.html#encoding)
Having looked into the encryption provider I am not sure this will be able to be added without creating your own jdbc extension, so I would recommend removing the password from the Access database file and testing again to see if this works.Cheers,
Neal
Hello, thanks for the answer
Ok, I have done the test without password and it works fine.
Now I have a second problem. How can I create the data source if the access database is in an ftp location (with username and password)?
Regards!
Hello, thanks for the answer
Ok, I have done the test without password and it works fine.
Now I have a second problem. How can I create the data source if the access database is in an ftp location (with username and password)?
Regards!
Hi Daniel,
Glad my suggestion worked for you. Unfortunately I do not know if that will be possible or not, though I would be inclined to say that you probably will not be able to do this. You would need to reach out to the UCanAccess community to see if anyone has experience in using this over FTP. I had a quick test and it does not look like their driver supports the use of the ":" character which would be required to specify an FTP port (or the ftp protocol itself), so I do not think this is possible, but the wider UCanAccess community may be able to help.
Was there any other questions you had?
Cheers,
Neal
Hi Daniel,
Glad my suggestion worked for you. Unfortunately I do not know if that will be possible or not, though I would be inclined to say that you probably will not be able to do this. You would need to reach out to the UCanAccess community to see if anyone has experience in using this over FTP. I had a quick test and it does not look like their driver supports the use of the ":" character which would be required to specify an FTP port (or the ftp protocol itself), so I do not think this is possible, but the wider UCanAccess community may be able to help.
Was there any other questions you had?
Cheers,
Neal
Hello!
No, thanks for Everything!
Hello!
No, thanks for Everything!
Hi Daniel,
Always happy to help.
Cheers,
Neal
Hi Daniel,
Always happy to help.
Cheers,
Neal
Replies have been locked on this page!