Connect to a remote Access DB from Talend

[asridhar7]

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. 

[Anonymous]

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.

[asridhar7]

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

[Anonymous]

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