Problems setting a SQL Server connection

[test.guillaume]

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: [Microsoft][ODBC SQL Server Driver]

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. [exit code=0]

 

I use Talend2 M3 ;)

 

Thanks for your help :)

 

posted in talend forum : http://talendforge.org/forum/viewtopic.php?id=445

 

Post edited by: test.guillaume, at: 2007/03/30 15:26

[jwalker]

The answer is in your question:

 

..

Nom d'objet 'DimCustomer' non valide.

..

[test.guillaume]

thks for your answer :)

 

If I do the same query in Microsoft SQL Server : select FirstName, LastName from DimCustomer

 

I have the good result in SS05 but nothing in Talend :/

Post edited by: test.guillaume, at: 2007/04/02 08:25

[test.guillaume]

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. :blink: :whistle: :woohoo: