connect to access database

[Gabri11]

Hi, I need to connect to a microsoft access database. The problem that talend is installed on a linux machine while the database on a microsoft machine
Does anyone know how I can connect and what string to use?
Thank you

[Gabri11]

yes, the problem is that if I connect to the acces database copied to the same machine where it runs talend (linux) then the job works. But if I try to connect to the database access on the windows machine then an error appears.

[JR1]

The access file is present in a folder shared over the network, correct? Can you access this folder from within linux? The Access connection relies on an accessible  file.

[Gabri11]

Exactly, could you tell me what is an example of a connection string to insert in talend (tAccess)? thanks a lot

[JR1]

In e.g. the tAccessConnection component, you do not have to provide a connection string. Simply provide the path & filename to your Access DB and Talend creates the connection string in the background.

If you need to provide additional parameters for the connection string, you can add them under "Advanced Settings --> Additional JDBC Parameters".

I hope this helps.

And by the way: you are running your job locally, correct? I.e. it is not built and deployed to a job server.

[moonshadow]

You should use mount command to achieve this task.

[Gabri11]

Sorry, What is the command mount?