Problems setting a SQL Server connection

_AnonymousUser — Sat, 16 Nov 2024 14:37:17 GMT

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#23161

Re: Problems setting a SQL Server connection

_AnonymousUser — Mon, 02 Apr 2007 09:41:58 GMT

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.

Re: Problems setting a SQL Server connection

Anonymous — Sat, 26 Mar 2016 11:23:40 GMT

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!!!

topic Problems setting a SQL Server connection in Installing and Upgrading

Problems setting a SQL Server connection

Re: Problems setting a SQL Server connection

Re: Problems setting a SQL Server connection