access db connection issue

[Anonymous]

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?

[Anonymous]

Anybody ?

[Anonymous]

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

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

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