topic Re: access db connection issue in Talend Studio

access db connection issue

Anonymous — Wed, 20 Jan 2016 07:42:28 GMT

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.

jdbcdbcriver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=

Username:
Password:

Any suggestion or ideas?

Re: access db connection issue

Anonymous — Wed, 20 Jan 2016 15:48:59 GMT

Anybody ?

Re: access db connection issue

Anonymous — Thu, 21 Jan 2016 05:49:05 GMT

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

Re: access db connection issue

Anonymous — Thu, 21 Jan 2016 06:20:44 GMT

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 ?

Re: access db connection issue

Anonymous — Thu, 21 Jan 2016 06:34:58 GMT

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

Re: access db connection issue

Anonymous — Thu, 21 Jan 2016 06:39:35 GMT

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