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!