Ian McGowan said:
I have a read-only login to a MS SQL Server database. I can connect, and the various databases on the server show up in DB Connections.
The problem is when I try to do an analysis. The queries seem to be failing due to how the connection is being made to mssql.
If I right click on a table and choose "Preview Table" I get an invalid object error. The SQL is
select * from dbo.Heat.Activity
If I change this to
select * from Heatdb.Activity
Everything is fine. Is there a way to ask TOP to use heatdb as the schema name, rather than the default dbo.Heat? It may very well be a problem on the mssql side - it's not my usual bag, baby. Honest!
The query "select * from dbo.Heat.Activity" seems strange to me (but my experience with MSSQL is almost null). What is "Heat" in this query?
In your second query, you wrote "Heatdb.Activity". Are "Heat" and "Heatdb" the same thing? Is it just a typo error, or are they really different?
Apart from this, I'm affraid this is a bug in the "preview table" menu, not in MSSQL.
For the analyses, you can see each executed query in the error log view: "Window > Show view > General > Error Log". But it seems to me that you will get the same kind of query.
I suggest that you open a bug issue on our bugtracker (http://www.talendforge.org/bugs/my_view_page.php) and this will be fixed as soon as possible.
Thank you for your support,