Hi,
I try to extract 2 fields of the DimCustomer who is a table of the Microsoft SQL Server 05 (AdventureWordksDW sample). I would put the result in an Excel files.
DBconnection show me ok when I check with ODBC Generic and M$ SQL Server ODBC.
My query : "select FirstName, LastName from DimCustomer"
The error :
Starting job TEST1_Prior_test at 14:16 28/03/2007.
Running process with context: Default
Exception in component tDBInput_1
java.sql.SQLException: Nom d'objet 'DimCustomer' non valide.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
at talenddemosjava.test1_prior_test.TEST1_Prior_test.tDBInput_1Process(TEST1_Prior_test.java:181)
at talenddemosjava.test1_prior_test.TEST1_Prior_test.main(TEST1_Prior_test.java:379)
Job TEST1_Prior_test ended at 14:16 28/03/2007.
I use Talend2 M3
Thanks for your help
edit : posted in JasperForge forum :
http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=19&id=23161#2...