Ms Access driver? Connection?

Hi,
I want to connect to an Access DB.
2 problems:
I don't need a login/pw but the component asks them?
And when I run it with my cred's to test it I have this:
Starting job Load_Data_From_HeadEnd at 09:54 28/01/2014.

connecting to socket on port 3535
connected
Exception in component tAccessInput_1
java.sql.SQLException: Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at voo.load_data_from_headend_0_1.Load_Data_From_HeadEnd.tAccessInput_1Process(Load_Data_From_HeadEnd.java:534)
at voo.load_data_from_headend_0_1.Load_Data_From_HeadEnd.runJobInTOS(Load_Data_From_HeadEnd.java:3398)
at voo.load_data_from_headend_0_1.Load_Data_From_HeadEnd.main(Load_Data_From_HeadEnd.java:3246)
disconnected
Job Load_Data_From_HeadEnd ended at 09:54 28/01/2014.


Do I need to install an extra driver for this?
Just to make sure not to install something wrong on the server, where can I find it?
Thanks!
9 REPLIES

Re: Ms Access driver? Connection?

Who can help?
Seventeen Stars

Re: Ms Access driver? Connection?

Please check if you can reach the ODBC connection outside from Talend with e.g. Excel. You have to check if the connection works correctly. Check if you can see an ODBC connection with the name used in your Talend connection in the Windows ODBC configuration.

Re: Ms Access driver? Connection?

Ok.
I only have SQL Server drivers.
It is on Windows Server 2008.
Is it this that I have to install then?
http://www.microsoft.com/en-us/download/details.aspx?id=13255
Thank you.

Re: Ms Access driver? Connection?

Installed it and I have this now?

Exception in component tAccessInput_1
java.sql.SQLException: General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x954 Thread 0xa2c DBC 0x4b510064 Jet'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at voo.load_data_from_headend_0_1.Load_Data_From_HeadEnd.tAccessInput_1Process(Load_Data_From_HeadEnd.java:534)
at voo.load_data_from_headend_0_1.Load_Data_From_HeadEnd.runJobInTOS(Load_Data_From_HeadEnd.java:3398)
at voo.load_data_from_headend_0_1.Load_Data_From_HeadEnd.main(Load_Data_From_HeadEnd.java:3246)
Seventeen Stars

Re: Ms Access driver? Connection?

Ok everything what Talend could do is done. You have to check your ODBC connection with a ODBC query tool. The problem is within the Windows ODBC configuration. I hate Windows so much and I would never ever use ODBC.

Re: Ms Access driver? Connection?

This is so not cool.
One Star

Re: Ms Access driver? Connection?

Hi,
I am not very experienced, but I hope the attached picture can help you to solve the problem.
With this procedure I had no problems to load data to Access
Best regards
Upload is not working:
- tAccessOutput
- Benutzername : ""
- Passwort ""
- Tabelle "the name of table"
- Action table: Clear
- Action data: insert
- built-in

Re: Ms Access driver? Connection?

Thank you but I'm suffering for the input atm. To access the accessdb.
I want to get data out the access db to have it in MSSQL.
Just connecting to the file is giving problems at the moment.
One Star

Re: Ms Access driver? Connection?

Take a look at this link. Hope it will help you.
http://www.talendforge.org/forum/viewtopic.php?id=30962
Thanks,
Jagadish.