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!
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.
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)
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.
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
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.
