Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Problems setting a SQL Server connection

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 0683p000009MA9p.png
Thanks for your help 0683p000009MACn.png
edit : posted in JasperForge forum : http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=19&id=23161#2...
Labels (2)
2 Replies
_AnonymousUser
Specialist III
Specialist III
Author

I found the problem !!!
In my ODBC parameter, in 3rd view of the assistant, I forgot to put the default database : AdventureWorksDW instead of master.
Anonymous
Not applicable

I found the problem !!!
In my ODBC parameter, in 3rd view of the assistant, I forgot to put the default database : AdventureWorksDW instead of master.


I got the same, i didn't put my database name.
That helps, thanks!!!