Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!!!