topic Re: Ms Access driver? Connection? in Talend Studio

Ms Access driver? Connection?

Anonymous — Tue, 28 Jan 2014 09:05:07 GMT

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!

Re: Ms Access driver? Connection?

Anonymous — Wed, 29 Jan 2014 10:29:16 GMT

Who can help?

Re: Ms Access driver? Connection?

Anonymous — Wed, 29 Jan 2014 22:48:20 GMT

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?

Anonymous — Thu, 30 Jan 2014 08:26:55 GMT

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?

Anonymous — Tue, 11 Feb 2014 10:23:43 GMT

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)

Re: Ms Access driver? Connection?

Anonymous — Tue, 11 Feb 2014 10:34:29 GMT

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?

Anonymous — Tue, 11 Feb 2014 11:30:30 GMT

This is so not cool.

Re: Ms Access driver? Connection?

Anonymous — Tue, 11 Feb 2014 19:47:44 GMT

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?

Anonymous — Wed, 12 Feb 2014 08:36:00 GMT

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.

Re: Ms Access driver? Connection?

_AnonymousUser — Mon, 24 Feb 2014 05:48:27 GMT

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-installing/td-p/115311
Thanks,
Jagadish.