topic Re: Connect to a remote Access DB from Talend in Talend Studio

Connect to a remote Access DB from Talend

asridhar7 — Sat, 16 Nov 2024 04:44:52 GMT

Hi,

I have Talend Enterprise Studio version and I am trying to connect to Access DB which is hosted on a remote Windows Server.

I used the below connection string and it fails.

Connection String - jdbc:ucanaccess:\\cussv0218fps1\\vol1\\Common\\Quality\\QC Inspections Test.accdb;jackcessOpener=org.talend.ucanaccess.encrypt.CryptCodecOpener;memory=false

File - \\servername\vol1\Common\Quality\QC Quality Test.accdb

I tried with QC Quality Test.mdb and it fails.

Re: Connect to a remote Access DB from Talend

Anonymous — Fri, 06 Sep 2019 17:16:08 GMT

The file name should be: //servername/vol1/Common/Quality/QC Quality Test.accdb.

Try that if it still failed, then you have to check the jackcess module to see if the file version and module version match.

Re: Connect to a remote Access DB from Talend

asridhar7 — Fri, 06 Sep 2019 18:55:21 GMT

ok, Thanks for the immediate reply. , will try and keep you posted.

Re: Connect to a remote Access DB from Talend

Anonymous — Fri, 07 Feb 2020 10:58:19 GMT

Hello,

I am trying to do the same i.e., connect to a remote access DB using ucanaccess. Did you succeed. If yes then please let me know.

Thanks
Charan