Ms Access driver? Connection?

[Anonymous]

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!

[Anonymous]

Who can help?

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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)

[Anonymous]

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.

[Anonymous]

This is so not cool.

[Anonymous]

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

[Anonymous]

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.

[_AnonymousUser]

Take a look at this link. Hope it will help you.
https://community.talend.com/t5/Design-and-Development/resolved-Unable-to-access-accdb-even-after-in...
Thanks,
Jagadish.