access db connection issue

One Star

access db connection issue

Hi

I'm trying to create accessDB version 2007 connection in Talend in Ubuntu.

But the concern is .mdb file are located on other machine.


May I know what would the connection string to access those files present in differnt machine?

Here is the default string which I get from talend while creating access db coonection.

So what extra I need to integrate in this string, like IP and .mdb file path present on different machine.


jdbcSmiley SurpriseddbcSmiley Very Happyriver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=

Username:
Password:


Any suggestion or ideas?
One Star

Re: access db connection issue

Anybody ?
Moderator

Re: access db connection issue

Hi,
We didn't connect to Access DB like this way, before. Can you move your .mdb file to your Ubuntu machine?
Best regars
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: access db connection issue

Hi Xdshi

So you mean I would not be able to connect ms access db which is present on other machine ? Right ?

Do I need to transfer .mdb files to my system only to access them ? This the only way to come out ?
Moderator

Re: access db connection issue

Hi,
Generally speaking, I haven't used it to connect ms access db which is present on other machine before.
We need make a further investigation on it to see if there is a better way to come out.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: access db connection issue

Please let me know, if you could find any way !! Smiley Happy

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch